Flag Priority only when certain criteria are meet

Hi All,

I have a gantt chart with a priority flag column. I want it to flag the row only when the date column is past today and % Complete column is less than 100%. The formula i am using is below and it is working to flag the row if the end date is past today but it does not clear the flag when the % complete is 100.

=IF(AND([End Date]@row < TODAY(), [% Complete]@row <> "100%"), 1, 0)

Thanks for any help!

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!