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 format using two columns



I have two columns Planned start and Actual start.


I can't seem to set a conditional formatting rule when Planned start is not equal to Actual start.


Please assist.




  • Jeremy Myers
    Jeremy Myers ✭✭✭✭✭
    edited 01/25/17

    1.  Make sure both source columns are formatted as date.


    2.  Insert a third column called "Calc Start Date" or something suitable and dump in the formula..  The below checks to see if there is a difference in the two dates.  


    =IF([Due Date]6 <> [Actual Start]6, "Not Planned Start", "OK")


    3.  Set conditional formatting to read the result if "Not Planned Start Date" and display red over the actual start date cell.

  • Thanks.  This is really helpful.

This discussion has been closed.