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
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
Comments
-
Cliff,
=IF(Finish2 > Baseline2, 1, 0)
Change the Formula 1,0 not 1,1
James
-
Hey,
Thanks James, that plus a rejig of my columns fixed it!
Cliff
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives