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.
Is it possible to highlight a row depending on what day it is...
Comments
-
The short answer is yes! I assume you want to highlight the row based on the day of the week. If that isn't what you want, you could do similar steps still to highlight it based on the actual date.
I think you'll need an extra column to do it though since this functionality isn't already built in to the conditional formatting tool. If you add an extra text column to your sheet and fill it with a formula like:
=IF(WEEKDAY([Date Column]1) = WEEKDAY(TODAY()), "True", "False")
Then you can apply conditional formatting based on this new column:
"If Same Day Column is "True" then apply this format to the entire row" (and choose your desired highlighting color)
I hope that answers your question! Let me know if something isn't clear.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives