Flag an item

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?



  • 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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!