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.
Compare two dates and apply conditional formatting
I have two columns of forecasted dates UTILITY and IN SERVICE. When the UTILITY date is past the IN SERVICE date I want both cells hilighted. For example if UTILITY = 9/30/17 and IN SERVICE = 5/10/17, I want both cells to be red.
I understand That I'll have to use a third column to base the formatting from but I cannot get the formula to work out correctly. All suggestions will be greatly appreciated.
Comments
-
Faith,
Try this in your third column...
=IF(UTILITY5 > [IN SERVICE}5, "Red", "Normal")
-
That worked perfectly. Thank you Brett!
-
That worked for me too - thank you! Seeing as this answer was posted about 16 months ago, I just want to add that I needed to adjust the formatting a little to only use brackets and parenthesis:
=IF([UTILITY]5 > [In Service]5, "Red", "Normal")
Thanks again!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives