Flag Priority only when certain criteria are meet

GlenM

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!

Heather Duff

Hi @GlenM ,

Try this:

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

In cells formatted as %, the values are displayed as % but internally are decimals. So, for example, 50% would be 0.5, and 100% would be equal to 1.

Hope this helps. Let me know if it works!

Best,

Heather

GlenM

Thank you very much it worked!

Heather Duff

Hi @GlenM ,

Try this:

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

In cells formatted as %, the values are displayed as % but internally are decimals. So, for example, 50% would be 0.5, and 100% would be equal to 1.

Hope this helps. Let me know if it works!

Best,

Heather

GlenM

Thank you very much it worked!

Heather Duff

@GlenM Glad it worked! Have a great week.