Template / Themes for Conditional Formatting

I would love to be able to be able to apply a conditional formatting template to any sheet I wished - much like a design theme in Office 365. And - if I change a rule, it would change it for all the sheets using that template. Can you imagine? How wonderful!

Sign in to vote!

Find more posts tagged with

On Wishlist

Conditional Formatting

Comments

PeanutRhombus

This would be insanely helpful. I am about to have to recreate the same set of 6 rules 13 times over because of this...

Rachel Paiva

I am a heavy user of Conditional Formatting for many purposes. The most powerful way I use it (to maintain schedule accuracy) is as an error checking mechanism (e.g.: format Start date in red if it's in the past but the Status value indicates that the task is still active). So I have MANY rules that have become more and more complex as I continue to evolve them over time.

I create my own custom sheet templates primarily so I can apply those rules when spinning up new project plans. But whenever I decide to change any rules, I have to go back and manually update them in all of my existing Smartsheets individually. This can take a lot of time because I manage many projects at once.

I'd love to be able to save my Conditional Formatting scheme as sort of a standalone template that can be applied to existing projects as well as new ones. I have no idea if it's feasible but had to ask :)

Annaleah Morrow

Absolutely would love this feature!

Brandon Fraire

This is a great idea! Also, I would like to be able to change the color options (similar to dashboards).

Connor2767472

Hello, I use a lot of conditional formatting logics across multiple similar sheets. As we make incremental changes, I often have to completely tear out individual conditionals and then rebuild them. If there are two changes/sheet and we have 15 sheets, I'm suddenly deleting 30 changes, which requires finding the old conditional in the long list, carefully deleting it, modifying the column type, then rebuilding the logic. It would be great if I could make the change once then "copy/paste" the relevant formatting rules to all the new spreadsheets.

Darren Mullen

@Rachel Paiva @Connor2767472

If you're open to using a browser extension for this, we have a solution.

https://smartsheetguru.com/2024/12/07/copy-conditional-formatting-rules-in-smartsheet/

it would be nice if these formatting rules were exposed over the API, but the browser extension provides many efficiencies while Smartsheet works on a solution.

Quick Links

Trending ideas

Attachments in Cells
I rely heavily on Smartsheet’s Document Generation. However, this workflow is currently dependent on having photos stored inside cells, since row attachments alone cannot be used directly in document generation.. If Smartsheet allowed attachments to be displayed as thumbnails in cells (as a reference), document generation…
WorkApp Analytics
I’d like to see user analytics for WorkApps. I’ve checked the user report available in the Collaborator Pack, but it only shows how many times someone has clicked into the WorkApp each month. I’d like to know: Which resources (dashboards, sheets, forms, etc.) are getting the most traffic? Where are people spending their…
Editable email Subject header from Smartsheet Notification
Hi There, I would like to propose that Smartsheet considers the email subject header that is received from a Smartsheet notification from a form or sheet. Currently, because not everyone in my company has Smartsheet, let alone a Smartsheet log-in, we need to send show the name of the owner of the sheet, that appears on the…