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.4K Get Help
- 447 Global Discussions
- 144 Industry Talk
- 478 Announcements
- 5K Ideas & Feature Requests
- 85 Brandfolder
- 151 Just for fun
- 72 Community Job Board
- 490 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 302 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!