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.
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!
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
How did it go? Did you get it working or do you still need help?
Hello. Trying to make a quick attendance tracker for a meeting. I got conditional formatting to change the cell color when its checked vs unchecked. However I cannot seem to find a way to get the rule to apply to multiple columns on a per column basis. I need a way to copy what I have for column 3 and apply it to all…
Hey Smart Heads, I have another question about our beloved topic of formulas. Background: I have a autogerated column with row created date. In the file, rows are added in 2 ways: In bulk, by senior auditor Ad-hock by auditor I would like to diferentiate these two types of inflow. I came up with an idea of finding…
What I intended to do is super simple: bring two sheets into one Row Report and do a simple pie chart on the status field. -> Source Data: two sample sheets A&B have exactly same fields. and the status is a dropdown list with single value -> The roll up row report, only picked the status field from the two source sheets.…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.