Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Conditional formatting based on date column entry being past another date column entry.

 I have Finsh date clearly and have put another column for Actual finish.  If the Actual date is before or after the original Finish date I would like to be able to format it.  Is there a way to do this?


  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    edited 12/23/15



    By formatting, you likely are looking for Conditional Formatting.

    You can't use formulas directly there, so you need another column.


    A checkbox column with this:


    =IF([Actual]23 <> [Actual finish]23, 1)


    will set the check box true when the Actual and Actual finish are different.

    You can then use Conditional Formatting on that field.


    Hope this helps.



This discussion has been closed.