How do I get conditional formatting rules to update based on "today" as the date.
Hi All!
I have conditional formatting set up that is looking for tasks that are due to start today (see first picture below). I chose the "Today" button when I set these up, but they populated today's date and they don't automatically update when I open the project plan after initial set up. In the help library, the example shows that I should be able to use "today" in the formula...see second picture below highlighted item. How do it set that up? Thanks in advance! Patti
Best Answer
-
When selecting the start date column, there should be an option for 'is today'. The following conditions would be start date 'is in the past'. This method should remove the option to select an actual date.
Answers
-
When selecting the start date column, there should be an option for 'is today'. The following conditions would be start date 'is in the past'. This method should remove the option to select an actual date.
-
Thank you! I completely missed that option. Patti
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 459 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 137 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!