Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
Is there a way to copy conditional formatting to multiple columns?
Answers
-
Sadly not @JMcLauglin
You can clone a rule but have to create the logic again for the new column. I know this has been requested many times but the closest enhancement request I can find right now is this one. You can add your vote and commentary:
-
Hi @JMcLauglin and @KPH,
This is possible with SSFeatures.
With SSFeatures you can click this "Clone Rule for Columns" button, then select the columns that you want to copy it for, and then SSFeatures will create all of the rules for those other columns.
Hope this helps!
Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com) (LinkedIn)
SSFeatures - The browser extension that adds essential features into Smartsheet.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.5K Get Help
- 466 Global Discussions
- 156 Industry Talk
- 510 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 156 Just for fun
- 81 Community Job Board
- 520 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 307 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- QUESTION: How to create a Text string output from a formula that can be copied and pasted into other applications. BACKGROUND: I have a large project that requires many Discovery sessions and have a s…
- I currently have this formula working to return the Store number that is Type - TRH. =INDEX(COLLECT({Copy of Construction-Checklist STORE NUMBER}, {Copy of Construction- TYPE 3}, "TRH"), Number@row) H…
- I am currently using the formula: =INDEX(COLLECT(Task:Task, Level:Level, 2, Status:Status, <>"Complete", Summary:Summary, 0), 1) to collect the next task due that is not completed for my summary secti…