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
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 142 Industry Talk
- 473 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 489 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives