Red Flag for overdue tasks

Ruth Potts

Hi,

I have used the formula =IF(AND([% Complete]@row < 1, [End Date]@row < TODAY()), 1) in the flag column to turn the flag red when the end date is passed and completion is less than 100% which is great.

BUT....

It now red flags every row that doesn't have a date in yes which is an issue as we are using a project management template which will house all backlog items etc that may not yet have dates allocated to them. Is there a way to stop this happening and only run the flag when there is a end date and % complete in the row but not when it is blank?

Thankyou!!

Jason Tarpinian

Just wrap everything you have in another IF blank statement.

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

The symbol for blank is two adjacent quotation marks.

Jason Tarpinian

Just wrap everything you have in another IF blank statement.

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

The symbol for blank is two adjacent quotation marks.

Ruth Potts

That is perfect! Thankyou very much

tylermh

@Jason Tarpinian How about an IF/COUNTIF formula for an automatic flag when a contact's name appears in the Contact column for a 3rd time? (incident tracking report)