I need a formula to flag a task
I need help with a formula.
I want to use this formula for the Due Date but I need to modify it so I can add in criteria if the Start Date has been passed & the task Status shows either Delayed or Not Started
=IF([Due Date]@row = "", "", IF(AND(OR(Status@row = "Not Started", Status@row = "Assigned", Status@row = "Scheduled", Status@row = "In Progress"), [Due Date]@row <= TODAY(-2)), 1, 0)
Thanks
Answers
-
I presume you want "1" to appear (or the flag to be checked) with the additional criteria, is that correct?
If so, we can add these statements into your AND function within another OR, like so:
=IF([Due Date]@row = "", "", IF(OR(AND(OR(Status@row = "Not Started", Status@row = "Assigned", Status@row = "Scheduled", Status@row = "In Progress"), [Due Date]@row <= TODAY(-2)), AND(OR(Status@row = "Delayed", Status@row = "Not Started"), [Start Date]@row > TODAY())), 1, 0)
Cheers,
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!