Flag Formula
Hello,
I am attempting to create a formula that if a presentation date = today and the status is either "Not started" or "In Progress" the flag will go off. I feel I am so close but keep getting an error.
=IF([Presentation Date]@row = TODAY(), Status@row = "Not Started", 0, OR([Presentation Date]@row = TODAY(), Status@row = "In Progress", 0))
Best Answer
-
I think you're missing some ANDS and ORS. Try this one. It will set the flag to 1 if the conditions are met and 0 if they are not.
=IF(OR(AND([Presentation Date]@row = TODAY(), Status@row = "Not Started"), AND([Presentation Date]@row = TODAY(), Status@row = "In Progress")), 1, 0)
Answers
-
I think you're missing some ANDS and ORS. Try this one. It will set the flag to 1 if the conditions are met and 0 if they are not.
=IF(OR(AND([Presentation Date]@row = TODAY(), Status@row = "Not Started"), AND([Presentation Date]@row = TODAY(), Status@row = "In Progress")), 1, 0)
-
Thank you so much David. Worked perfectly!!!
-
Awesome! Glad to hear it.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 430 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 75 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!