Checkbox tick then auto highlight certain columns?
Hi,
We have a sheet called project milestones for managing the steps of LIVE manufacturing an installation projects.
I'd like when our production manager selects a tick box on a specific row, that 4no columns within the row are automatically highlighted light green.
The column "In production/ Approval Docs uploaded" Should be the driver,
Then whenever a row is ticked, the "Project No"/ "Customer" / "PM" and "Project Ref" in that specifc row turn light green
Image attached
Community.........How do I do this?
Thanks in advance
Comments
-
Hi Stuart,
You would do this thru conditional formatting.
Please see the attached link/screenshot for more information.
EDIT: Added how to do it more in detail. https://cl.ly/c05159
https://help.smartsheet.com/articles/516359-conditional-formatting
I hope this helps you!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!