Hide Errors Until Cell is Populated
I'm calculating the variance between dates using the following formula. The problem is that an error is displayed if the Actual Start Date is not populated as show in the screenshot.
Formula used in Variance Start Date:
=NETWORKDAYS([Planned Start Date]3, [Actual Start Date]3) - 1
Is it possible to have the Variance Start Date cell blank if there is not an Actual Start Date defined by adding something to the formula above?
Comments
-
Hi,
Yes, you can add an IFERROR function at the beginning of the formula.
More info: https://help.smartsheet.com/function/iferror
Would that work?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Yes! Just wrap your formula in an IFERROR function.
=IFERROR(NETWORKDAYS([Planned Start Date]3, [Actual Start Date]3) - 1, "")
-
You can also put it in a regular IF statement.
IF(ISDATE([Actual Start Date]@row), NETWORKDAYS([Planned Start Date]3, [Actual Start Date]3) - 1)
It will have exactly the same result as Andree's and Mike's suggestion above. It's just another option.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
-
Perfect. Thank you very much!!!
-
Excellent!
Happy to help!
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Haha. I had opened this thread in a new tab earlier in the morning and forgot to refresh it later when I got a chance to look at it. When I posted my response I saw I was late to the party, so I hurried up and did some quick editing with my *this works the same* disclaimer. Haha
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Haha. It's just a good reminder to the community that it's possible to come at a solution from multiple angles and get your results in a variety of ways.
-
So true. Some harder than others when you start over-thinking. Haha.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!