Flag Formula



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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!