nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

Copy colour format from one sheet to another

ahumne

Hi I want to copy the colour formatting of all the columns in one sheet to around 50 other sheet.

Is there a way to do it? Currently I have to format each sheet individually.

Paste Special is not working for me to copy the format.

Thanks,

Adarsh

Find more posts tagged with

Comments

Andrée Starå

Hi Adarsh,

Unfortunately, it's not possible at the moment, but it's a great idea!

Please submit an Enhancement Request when you have a moment.

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

You could "Save as new" on the sheet, open the new sheet, delete the data but leave the formatting, and then either "Save as New" multiple times or "Save as Template" and use the template multiple times.

Ezra

Brought this up a while ago too...

https://community.smartsheet.com/discussion/time-formats-number-formats-rethinking-ux-and-function

Paul Newcome

I just added to your thread...

Sign in to join the conversation!

Quick Links

Trending discussions

"Fields marked with an asterisk (*) are required." line on every form.
Hi, "Fields marked with an asterisk (*) are required." is the very first line in the body of every form I create. I don't remember seeing it before (unless you missed filling out a required field; then you would see the message). Is there a way to turn it off or change it? None of my forms are in English so the message is…
Best Way to Create a Stacked Bar Chart from multiple columns
I have a sheet that I pull into a report. The report I then want to use to make a stacked bar chart and put into a dashboard if I can. The columns I am trying to make into a stacked chart are: Lead, project and phase. The issue is that there are several leads and I need the stacked bar chart to show in different colors for…
Dynamic View Issue - Group Sharing
I have a dynamic view setup for a dashboard that has NO restrictions And on the Sharing tab, I have a Group that I created as the additional share access to the view But the individuals in the Group still cannot see the data from the dashboard. Am I missing something? Because when I share the view to them individually…