Sign in to join the conversation:
Is there a way to create a formula that only runs if there is a date in a specific coloumn? We are trying to see turnaround times but do not want to see #invalid if the document has not been exected yet.
Hi,
Yes, you can add an IFERROR function to the formula.
More info: https://help.smartsheet.com/function/iferror
Hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
How did it go? Did you get it working or do you still need help?
I'm looking for some advice or suggestions on sheet layout. Attached is an apartment "booking" sheet, all currently manually entered from another source form. As you can see it's not well laid out, it doesn't easily show periods when a given room might (or might not) be available. In general, just very janky. But, I can't…
Hi everyone, I have a Smartsheet that has requests for updates that go to 10 different departments. We are asking that each step in the process be completed within 24 hours. I would like to track the time it takes to complete each step. Here's the complication, there are requests that go out to say 3 different departments…
Does anyone know how to generate a chart like the one in the picture in Smartsheet? We want to show planned hours vs worked hours by month by team. Thanks!
