Help with IF/THEN Network days formula when another field is marked Yes or No
Trying to calculate Network days between two date fields. If one of the dates is blank, then the calculation between the dates uses Today. The formula works great, but in some cases, I won't have dates populated for either field (another field named Comments with selection of Yes or No would be completed). So I want the formula result to remain blank and need to add in an IF/THEN type criteria to only run when the Comment Field = Yes (meaning there would be a dates needed in those fields). Any ideas?
=IF(ISBLANK([CMO Feedback Received Date]@row), NETWORKDAYS([Batch Record Review Complete (Date)]@row, TODAY()), NETWORKDAYS([Batch Record Review Complete (Date)]@row, [CMO Feedback Received Date]@row))
Best Answer
-
Resolved through the use of the AI formula generator. 😀
Answers
-
Resolved through the use of the AI formula generator. 😀
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!