Flag Formula

Michele Thomas

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))

David Tutwiler

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)

David Tutwiler

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)

Michele Thomas

Thank you so much David. Worked perfectly!!!

David Tutwiler

Awesome! Glad to hear it.