Conditional Formatting Cloning
Hi SS Community,
I have a colleague who has a sheet with a ton of CF rules (which are applied to months/years ie. June 22, Jul 22, Aug 22, etc). He would like to clone a rule and then change the "condition" part to different month so the same formatting will apply without having to manually re-enter the rule. ie. If " Test Aug 22" is greater than 0.90, then apply a green background to the entire column. He wants to CLONE this rule, and then change "Test Aug 22" to "Test Sept 22", and leave the rest of the rule as is. Is this possible?
From what I've been reading in similar posts, it doesn't look like SS has that capability yet, but I thought I would ask.
Thanks!
Brad
Answers
-
Paul Newcome ✭✭✭✭✭✭ -
Bradhickswa ✭✭
@Paul NewcomeI know of that capability, however, if I wanted to change the "set condition" part, it erases the rest of the cloned rule and I'd have to re-enter it manually again. I was wondering if there was a way to be able to change the set condition and keep the rest of the rule without deleting it.
-
Paul Newcome ✭✭✭✭✭✭
我以前没有这个问题。每当我有cloned a rule, I can change each piece of the rule independently without affecting the other pieces.
thinkspi.com
Categories
As long as your destination sheet doesn't have the numbering column setup as an Auto Number, you should be fine. In your destination sheet, keep the numbering column as a \"Text\/Number\" column instead.<\/p>
BRgds,<\/p>
-Ray<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":334,"urlcode":"automations","name":"Automations"}]},{"discussionID":107872,"type":"question","name":"Using Sum function on 2 referring pages","excerpt":"I am trying to sum to different cells on 2 different Smart Sheets and I I keep on getting a #UNPARSEABLE error. It works fine when it references only 1 sheet but I need to sum probably about 20+ sheets when I am done. Just testing with 2 right now. Any help is appreciated =SUM({AAA Pet Services - Sign Ups Range 1}{AAA Pet…","snippet":"I am trying to sum to different cells on 2 different Smart Sheets and I I keep on getting a #UNPARSEABLE error. It works fine when it references only 1 sheet but I need to sum…","categoryID":321,"dateInserted":"2023-07-20T17:37:32+00:00","dateUpdated":null,"dateLastComment":"2023-07-20T18:10:31+00:00","insertUserID":163722,"insertUser":{"userID":163722,"name":"John C0","url":"https:\/\/community.smartsheet.com\/profile\/John%20C0","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-20T18:10:00+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":163722,"lastUser":{"userID":163722,"name":"John C0","url":"https:\/\/community.smartsheet.com\/profile\/John%20C0","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-20T18:10:00+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":29,"score":null,"hot":3379752483,"url":"https:\/\/community.smartsheet.com\/discussion\/107872\/using-sum-function-on-2-referring-pages","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107872\/using-sum-function-on-2-referring-pages","format":"Rich","lastPost":{"discussionID":107872,"commentID":386231,"name":"Re: Using Sum function on 2 referring pages","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/386231#Comment_386231","dateInserted":"2023-07-20T18:10:31+00:00","insertUserID":163722,"insertUser":{"userID":163722,"name":"John C0","url":"https:\/\/community.smartsheet.com\/profile\/John%20C0","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-20T18:10:00+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-20T18:10:07+00:00","dateAnswered":"2023-07-20T17:56:18+00:00","acceptedAnswers":[{"commentID":386226,"body":"
=SUM({AAA Pet Services - Sign Ups Range 1}, {AAA Pet Services - Sign Ups Option 2 Range 1})<\/p>
A comma is needed between each range to sum.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":107832,"type":"question","name":"Is there a way to exempt people from a Workflow Automation Process?","excerpt":"I created a Smartsheet for a team calendar. I created a Form attached to the Smartsheet for the team to request new \"events\" and be able to get them added to the calendar. Then, I created an Automation Process for Approval when \"rows are added\" and set it up to leave the row upon approval and delete the row upon rejection.…","snippet":"I created a Smartsheet for a team calendar. I created a Form attached to the Smartsheet for the team to request new \"events\" and be able to get them added to the calendar. Then, I…","categoryID":321,"dateInserted":"2023-07-20T01:53:10+00:00","dateUpdated":null,"dateLastComment":"2023-07-21T07:32:10+00:00","insertUserID":163703,"insertUser":{"userID":163703,"name":"MJ2424","url":"https:\/\/community.smartsheet.com\/profile\/MJ2424","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-21T02:05:29+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-07-21T09:44:28+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":19,"score":null,"hot":3379744520,"url":"https:\/\/community.smartsheet.com\/discussion\/107832\/is-there-a-way-to-exempt-people-from-a-workflow-automation-process","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107832\/is-there-a-way-to-exempt-people-from-a-workflow-automation-process","format":"Rich","tagIDs":[204,334],"lastPost":{"discussionID":107832,"commentID":386319,"name":"Re: Is there a way to exempt people from a Workflow Automation Process?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/386319#Comment_386319","dateInserted":"2023-07-21T07:32:10+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-07-21T09:44:28+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-21T02:05:26+00:00","dateAnswered":"2023-07-20T11:52:04+00:00","acceptedAnswers":[{"commentID":386119,"body":"
Hi @MJ2424<\/a> <\/p> I hope you're well and safe!<\/p> You could add a so-called helper column. It could be a checkbox column; then, you add that as a default value to the form and hide it. Update the workflow so it only triggers when that column is checked.<\/p> Make sense?<\/p> Would that work\/help? <\/p> I hope that helps!<\/p> Be safe, and have a fantastic week!<\/p> Best,<\/p> Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p> ✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":204,"urlcode":"Forms","name":"Forms"},{"tagID":334,"urlcode":"automations","name":"Automations"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=321&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":4865,"limit":3},"title":"Trending in Smartsheet Basics","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
