Global Conditional Formatting
Hi, is there any way to have Smartsheet apply conditional formatting to any cell that matches a criteria? Let's say I have a sheet with 50 dropdown columns containing "Pass", "Fail", "Remediated", or "N/A". I want any cell that contains "Pass" to be green, "Fail" to be red, etc. It looks like I have to write a conditional rule for each cell at the moment, which would result in 200 different rules. Is there a better way?
Answers
-
hi @Topher Barnett,
Perhaps you contact @SSFeatures about this. With their solution (https://ssfeatures.com) I think this will perfectly fit your challenge. -
Hi @Topher Barnett, I'm Nathan Braun, the developer and founder for SSFeatures.
With SSFeatures you can create the 200 rules in a few seconds with just a couple clicks of a button.
- Create one conditional format rule for one of your columns.
- Click the Clone Rule for Columns button.
3. Select the columns that you want to clone the rule for.
4. Press "OK" and then SSFeatures will generate all of the conditional format rules for you.
You can read more about this feature on this "Bulk Clone Conditional Formats" page. And you can see all of the other features that SSFeatures adds on this "Features" page.
Just for fun, @Protonsponge created this masterpiece with ~1700 conditional format rules using this method.
Please let me know if you have any questions.
Best!
Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com) (LinkedIn)
SSFeatures makes Smartsheet way easier to use and it saves you hours of work every week. It adds essential features into Smartsheet to save you time. For example: — Auto Sorting — Sorting with Filters — Report PDF Generation — Copy and Paste Conditional Formats — Copy and Paste Automation Workflows — Column Manager — and so many more.
