Is it possible to create a heat map using conditional formatting?
Would like to create a heat map using conditional formatting, but without applying the same rules to every column one by one. I have 12 columns and 4 conditions (for green, yellow, orange, red color) based on cell values that need to be applied to all cells across 12 columns OR at least a easier way to reapply the conditions to each of the 12 columns (like a format painter). [Btw, I am aware of the fact that you can clone a rule in the conditional formatting dialog, but look for much easier and better options]
Answers
-
Unfortunately you can't say "If any cells in these five columns equals this value, make that cell red". Super pain. If there are any interdependencies between the cell entries, you may be able to leverage that to reduce your count of conditional formatting entries, but otherwise I think you're stuck.
-
Thanks for your input @Lucas Rayala. Smartsheet is very column driven and so restricts a lot of functionality in the sheet.
It would have been awesome if a common criteria/condition could have been set on multiple columns (just like we can apply the formatting to multiple columns when setting up the conditional formatting)
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 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
- 282 Events
- 36 Webinars
- 7.3K Forum Archives