-
Why isn't project manager working?
Hello everyone, We have our Control Center set up with the help of Smartsheet. When we set up Control Center we made a column titled "Project Lead". We decided that "Project Manager" was a better fit. We updated all columns and all the metadata to reflect this change. However, all we get is «Project Manager» to appear in…
-
Conditional Formatting multiple cells when equal to value of another cell?
Hello! I need help with conditional formatting in my sheet. I have 8 columns that are fixed to Employee Names (for shift schedules). I want the functionality for someone to go in and select their name from a dropdown and then have their shift times (when their name is in a cell) to be highlighted. I have another column…
-
Formula calculating Status on Parent and Child Rows
Right now, the overall project status formula displays as "Complete" only if all the checklist items are marked as "Completed". We have been asked to update the formula so that it if all checklist items are marked "Completed" OR "Cancelled" the overall project status will be "Complete". The "Tasks Not Needed" references a…
-
Adding Images in Form Body and Descriptions
Currently, I am using Google form to capture responses because of the easy creation logic using section builder and adding images to the questions. It would be great if the smartsheet form had the same capability as google form with easy creation of logical questions by adding images with the questions.
-
Why are my formulas suddenly not working?
Hi, I have created formulas in the past and have even used your AI helper option to create formulas with good results. Yet, over the past couple of days whether I use AI or create a formula I am getting either an unparseable error or some other error. Please help. I am simply trying to count the number of in progress items…
-
Help with Verification Step of Webhook Creation Using Bridge
I am trying to use the Bridge API Call Utility to create a webhook on a sheet. I then want to use the Bridge Inbound Webhook integration to monitor sheet activity via the webhook and trigger a Bridge Workflow. I am able to create the webhook, but I'm having trouble figuring out how to complete the Verification Process. Can…
-
don't find Smartsheet in Teams desktop
a client of my organization told me that she can no longer find the Smartsheet application in Teams desktop/web, but it is found in the Android/Iphone versions, the application was authorized and available in Teams but it cannot be found more . I only see Smartsheet EU. Is this a problem on our side or a change that I am…
-
If statement using date less than number of days
Hi, I am trying to write a statement so say if the date in the column is over 10 years from that date, I need to flag it if not then no flag. Any suggestions?
-
IF logic formula
Hello, need help. I created formular for two outputs - "OTD" or "Not". See attached snip for details: A) Test 2 and 3 with date = Correct outputs, but for b) Test 4 without date = Same fx, still output "OTD" doesn't make sense. What do I need to do? C) For Test 1 formular seems working. But I'd like to incorporate into one…
-
Problem with Multi-sheet Report interpreting identical columns as unique
I am having difficulty with not understanding how to force SmartSheet row reports to understand that a particular column I have on multiple sheets is indeed the same thing, and I want it displayed on the report as a single column. It somehow does this automatically and sometimes correctly identifies this, other times not.…
