Helper Column to compare Dates
Hi,
I am working to figure out a way to compare actual project dates to planned project dates. I linked the actual project dates from our active program view.
If the Actual End date does not pass the Planned End date I want the "State" Column to be green.
If the Actual End date is past the Planned date but within 21 days, I want the "State" Column to be yellow.
If the Actual End date is more than 21 days past the planned date then I want the "State" column to be red.
Can I do this with a formula in the state column or do a helper column? If so, what would the formula be?
Thank you!
Best Answer

You can do this as a formula in the State Column. OR as a column formula which would help prevent it from being edited.
=IF([ACTUAL END]@row <= [Planned End]@row, "Green", IF([Actual End]@row <= [Planned End]@row + 21, "Yellow", IF([Actual End]@row > [Planned End]@row, "red")))
For more on column formulas see:
Answers

You can do this as a formula in the State Column. OR as a column formula which would help prevent it from being edited.
=IF([ACTUAL END]@row <= [Planned End]@row, "Green", IF([Actual End]@row <= [Planned End]@row + 21, "Yellow", IF([Actual End]@row > [Planned End]@row, "red")))
For more on column formulas see:

It worked. Thank you!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.7K Get Help
 63 Global Discussions
 68 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!