Conditional Formatting Help
I am wondering if there is a way in Smartsheet to be able to setup conditional formatting so that in a column called "Current" there is a cell in row 1 that has the logic to show that the current month is June-2022. I have this setup already (and so on July 1st it will switch automatically to July-2022.
What I want to do is in a different column setup conditional formatting to BOLD and UNDERLINE the current month (where the column is labeled Month and it has June-2022 in cell 1 ; July-2022 in cell 2 etc. I want the current month to be BOLD and UNDERLINE in that column and was trying to setup conditional formatting but am not finding how to setup the rule based on the value in a different cell.
Any thoughts?
Best Answer
-
Hi @Iastate7653
I hope you're well and safe!
Yes, but you'd need to reference the row 1 cell in the current column on all the other rows or add a so-called helper column where you reference to row 1 instead, and then reference it in the Conditional Formatting Rule(s).
Make sense?
Would that work/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.
Answers
-
Hi @Iastate7653
I hope you're well and safe!
Yes, but you'd need to reference the row 1 cell in the current column on all the other rows or add a so-called helper column where you reference to row 1 instead, and then reference it in the Conditional Formatting Rule(s).
Make sense?
Would that work/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.
-
Thanks Andree! I am not sure how to reference a row in the conditional formatting formula though.
My condition is:
1) Select column 1
2) Custom criteria "is equal to" and I can't figure out how to reference the cell that has the year in it.
-
I think I found a work around.... thx
-
Excellent!
Happy to help!
✅Remember! 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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 440 Global Discussions
- 138 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!