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

Yovanka Barnard
Yovanka Barnard ✭✭
edited 12/09/19 in Archived 2017 Posts

Hi,

 

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.

 

Y

Tags:
· Share on FacebookShare on Twitter

Comments

  • 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.

    · Share on FacebookShare on Twitter
  • Yovanka Barnard
    Yovanka Barnard ✭✭

    Thanks.  This is really helpful.

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories