Calendar View
I'm coming to the experts to figure this one out. I've created a list of tasks people must do on my sheet with all the normal data. I've also added a check box that each person will mark with their task is done.
I'm publishing in Calendar view, and I'd like to change the color of the task when it is checked. The calendar will then clearly show what is done and what is still outstanding.
Can this be done?
Answers
-
Within conditional formating there is a Task Bar option that I think will accomplish what you need.
So below it would be IF (box is checked) apply this format to the entire row, but only change the task bar option.
Let me know if this works!
-
No. I use conditional formatting all the time. It only changes on the sheet not the calendar. I can manually change the color but can't figure out how to get it to work on the calendar view
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 351 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 36 Webinars
- 7.3K Forum Archives