Flag an item

kaitlin.epps

I am trying to flag a line where the Actual Finish date is blank or the Actual Finish date is past the Estimated Finish date. How would I set that formula up?

Stacy Meadows

I am guessing you have the following as separate columns: Flag, Actual finish date, Estimated finish date,??

If so, I am guessing this is what you want to achieve?

Flag formula:

=IF(COUNTIFS([Actual Finish Date]@row, "") > 0, 1, IF(COUNTIFS([Actual Finish Date]@row, >[Estimated Finish Date]@row) > 0, 1))

I would then recommend converting it to a column formula to make an automatic process, see below if needed :)

select one row of the flag column and right click then select covert to column formula