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 - Target Dates vs Actual Dates

edited 12/09/19 in Archived 2016 Posts

Hey guys & gals


Basically I'm trying to get my actual task finish date to highlight green or red if it hits or doesn't hit the target date. 


I know I need a checkbox column to do this. I've added one with the following formula


=IF(Finish2 > Baseline2, 1, 1)


Finish2 = the first cell with the actual finish date

Baseline2 = the first cell with the target finish date


The formula should tick the box if the finish date is greater than the target date.


However it ticks the box is the finish date is greater than OR Equal to target. 


What am I doing wrong? 


Thanks for your help



This discussion has been closed.