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
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!