Help with a Function
I'm trying to have the flag check on when LATE in "Status" Column drop down is selected or if the "Estimated Completion Date" Column date prior to Today
Thanks again for all the help
Answers
-
See below corrected syntax
=IF(OR(Status@row= "LATE",[Estimated Completion Date]@row<TODAY()),1,0)
-
Thanks so much. Another quick question, if the date is blank the flag is check. what would need to be added to the function to not check the flag if date is blank?
Would there need to be an "=IF(ISDATE"
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 153 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!