Conditional Formatting (color coding)
I would like some assistance on the best way to color code rows and columns with multiple commands.
So, far I have created three forms and would like each form to be color code using colors that will inform researchers on its priority and to whom it should be assigned. I have been able to color code columns and rows with ease. For instance, each project number is bold, and if a project manager is not selected by smartsheet coordinator, that column turns into RED to show error there.
However, I cannot instruct the three requests to turn each column into one color despite having separate conditions for each requirement. I have tried to use the If "column name" contains "value1, value2, value3" format without any color changes to the relevant rows as chosen from the three forms. Now I do not know how the managers viewing this sheet can quickly know which ones to look at first and delegate.
Please help me with this formatting or a different method to change colors automatically.
Thanks in advance
Comments
-
Also, I meant to say turn the ROWS into multiple colors to show relevance and priority to viewers.
-
Hi,
Can you attach a screenshot of the sheet?
Best,
Andrée Starå - Workflow Consultant / Get Done
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Shem. Not fully understanding your scenario, but it sounds like you are using conditions to color code your rows.
Take note that the higher rows in the conditional format dialog take priority. Maybe you simply need to move up the conditions that are not working?
-
Hello all,
I was able to tinker with the conditional formatting a little bit more. All I needed to do was put more conditions for each dropdown option in every column. Then, I proceeded to format the rows to color each row to show relevance using traffic light colors (red, green, yellow).
Thanks for showing interest.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives