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 For Date Cell
Comments
-
Hi Marcia—There currently isn't a way to compare values in a sheet against one another to change formatting with conditional formatting rules but I'll pass your feedback along to our development team for further consideration.
As a potential workaround, you can create a checkbox column in your sheet and place an IF statement in it that will check the box when your one date is greater than your other date, example as follows:
=IF([Date Column]1 > [Other Date Column]1, 1)
Note that you'll need to change the column names in the formula above to the names of the date columns in your sheet.
You can then create a conditional formatting rule that changes the formatting if the box is checked.
-
+1 vote for Conditional formatting based on a data comparison between cells!
thanks
Mark
-
Hi Mark,
Got your vote down.
Thanks!
-
Hi,
Did this ever get implemented? Also looking for a simliar condition.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 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