Conditional Formatting Across Sheets
Hi, we have a Scheduling Sheet (with columns, wk 01, wk 02, wk 03, wk 04, etc). A Delivery Date column links into this sheet from another sheet.
What we do at present is highlight the relevant week column based on the date in delivery date, so for example from Jan 2nd to Jan 8th is wk 01 this year. (See screenshot attached)
The problem is the Delivery Dates can often change so the highlighted cell needs to then be manually changed. We are looking at a way of automating this and thought using conditional formatting might work, so that if the date falls within a certain range it highlights the relevant column (Screenshot attached).
We need to do this across multiple sheets so are wondering if there is any method where a Template or Master Sheet can be setup and the Conditional Formatting can then be applied to certain sheets without having to update each individually? Would Control Centre allow us to do this?
Answers
-
I hope you're well and safe!
Yes, It seems like it should work with a cell-linking or cross-sheet formula structure.
Please describe your process in even more detail and share the sheet(s)/copies of the sheet(s) or some screenshots. (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
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.
-
Hi Andree,
The screenshots on the previous emails pretty much capture what we are trying to achieve. I've shared the links to test sheets with you via email. If you have any questions please let me know.
Thanks, Emmet
-
Excellent! I'll take a look and get back to you!
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.
-
Hi @Andrée Starå, did you get a chance to look at this?
-
Hi @Andrée Starå, hope you are keeping well. Just checking if you had any solutions for the above issue?
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives