Red Flag Trigger based on multiple conditions
Hello! I am attempting to adjust the red flag trigger in a RAID log so that it only displays if the due date is in the past and the status is "In Progress" or "Not Started."
The other option would be if the due date is in the past or the status is not "Complete.
My equation attempts continue to return as unparseable.
All help is appreciated!
Best Answer
-
This will set the flag to active if the due date is is the past and the status is either In Progress or Not Started.
=IF(AND([Due Date]@row < TODAY(), OR([Status]@row = "In Progress", [Status]@row = "Not Started")), 1, 0)
Answers
-
It looks like you only missed an equals sign.
=IF(AND([Due Date]@row < TODAY(), [Status]@row = "In Progress"), 1, 0)
-
Thank you! This worked! Do you know if it is possible to also have the flag display red when "In Progress" or "Not Started?"
-
This will set the flag to active if the due date is is the past and the status is either In Progress or Not Started.
=IF(AND([Due Date]@row < TODAY(), OR([Status]@row = "In Progress", [Status]@row = "Not Started")), 1, 0)
-
Thank you so much!
This worked perfectly!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!