Conditional Formatting - One rule on multiple columns
Answers
-
Is there a way to select multiple columns and apply a single conditional format for multiple columns down the columns?
-
I will submit a product request but also want to echo this need. I need to have the same conditional formatting for ~15 rows where a cell is highlighted red if 'XL' is present, orange if 'L' is present, etc. Right now, I need to create 3 conditional formats per column x 15. That's....not efficient or sustainable. Conditional formatting should be able to cloned across columns - this seems like a fairly basic feature and something Excel does SO much better.
-
I was curious if there are any updates on this. I have a conditional formatting rule I need to clone across 15 columns, twice (2 different conditions). I don't really want to have 30 rules for one function...
-
Hi @jhorvath
I hope you're well and safe!
Unfortunately, it's not possible yet, but it's still an excellent idea!
Please submit an Enhancement Request when you have a moment.
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 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 this would be a much needed functionality.
-
I echo the need to have this function. I too am building (and have built) sheets using the conditional formatting the clone function just is to cumbersome. Its just easier to build a new rule each time. Have 18 columns and growing and need to set 3 color codes to highlight cell for a monthly metrics and if they are meeting, below, or way below (green, yellow, red) for their achievement that month. I see this thread started quite some time ago, but have not seen any updates coming through. Can someone give us an update on whether this submittal has been considered and /or is on deck for development. For efficiency purposes, which Smartsheets promotes, this would be a great win for a number of users.
-
Please and me to this bandwagon. This seems like kind of a no-brainer feature, and one that I need desperately.
-
Please add this feature. I just had to delete 732 conditional formats to change the column type and now I have to go back and add all 732 conditional formats back into the sheet.
-
+ Add this feature
-
+1, Add this feature
-
Seriously? We're still waiting for this? SMH.
-
A new user and needing this functionality too. Checking to see if it is available yet? Thank you
-
Can someone point me to this feature request, so I can pile on? This 'seems' like a simple enough request.
Honestly, the Conditional Formatting feature is incredibly useful, but is bogged down by literally a decade of neglect versus what could have been aggressive, strategic development to make it more powerful. Smartsheet seems to spend more time coming up with new features that to me are of questionable value than updating and strengthening its core offering.
-
Hey @Suzanne Raphael
Here's the link to the Product Idea relating to this feature request.
Cheers,
Genevieve
-
@Genevieve P. Cool, thank you very much. I am a big fan of Smartsheet, have used it for a very long time and carried it with me through several companies/been an evangelist. It's just frustrating...when you have a tool you love, you want it to be all that it can be. And you want to feel love in return, and sometimes I just really feel like as a user, my needs are not a priority.
