Is there a way to copy Conditional Formatting from one sheet to another using API ?

Pavel Bogatyrev

I have plenty of sheets per my project and need to apply the same formatting

Is there a way to copy Conditional Formatting from one sheet to another using API ? 

Andrée Starå

Hi Pavel,

Unfortunately, as far as I know, it's not possible at the moment, but it's 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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Pavel Bogatyrev

Thanks Andree,

I will :)

BTW - is there a way to see my ER, i have submit some already and would like to see it somwhere:)

Another proposal - consider some not core code to be pubilc - i have some brilliant ideas and would love to contribute :)

Andrée Starå

Happy to help!

Unfortunately, there isn't a way to see your submitted ER's. What I do and recommend is to send a copy to yourself for reference.

Here's a specific community for Smartsheet API, and that also might be a great place to share your brilliant ideas.

Newest 'smartsheet-api' Questions

https://stackoverflow.com/questions/tagged/smartsheet-api

Stack Overflow | The World’s Largest Online Community for Developers

I hope that helps!

A.J.

I just filed an EA about this same issue. Redoing the conditional setups for each sheet is very time-consuming.

SSFeatures

Hi @Pavel Bogatyrev and @A.J.

You can do this with SSFeatures. SSFeatures adds these copy and paste buttons into Smartsheet that you can use to copy and paste conditional formats between sheets.

This doesn't let you do this via the API, but you can do it directly in the Smartsheet app.