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
=IF([Date as Text Type]@row <> \"//www.santa-greenland.com/community/discussion/96061/\", DATE(VALUE(LEFT([Date as Text Type]@row, 4)), VALUE(MID([Date as Text Type]@row, 6, 2)), VALUE(MID([Date as Text Type]@row, 9, 2))), \"//www.santa-greenland.com/community/discussion/96061/\")<\/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":107081,"type":"question","name":"Users having issues with accessing published sheets","excerpt":"HI I have had several users reach out to me indicating they are no longer able to access a published sheet. They have been able to access in the past but now they are not. Nothing has changed with these published. Yesterday for one user, I deleted their account and re-added. Once he accepted the invitation, he was able to…","snippet":"HI I have had several users reach out to me indicating they are no longer able to access a published sheet. They have been able to access in the past but now they are not. Nothing…","categoryID":321,"dateInserted":"2023-06-29T14:13:17+00:00","dateUpdated":null,"dateLastComment":"2023-06-29T14:47:23+00:00","insertUserID":127983,"insertUser":{"userID":127983,"name":"Carol-Anne Cerbone","url":"https:\/\/community.smartsheet.com\/profile\/Carol-Anne%20Cerbone","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!h1jY4Qxc4TY!prNYaQRZvvo!a6wiwaB2GsY","dateLastActive":"2023-06-29T14:43:46+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-29T18:08:21+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":25,"score":null,"hot":3376099840,"url":"https:\/\/community.smartsheet.com\/discussion\/107081\/users-having-issues-with-accessing-published-sheets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107081\/users-having-issues-with-accessing-published-sheets","format":"Rich","tagIDs":[219,223],"lastPost":{"discussionID":107081,"commentID":383099,"name":"Re: Users having issues with accessing published sheets","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/383099#Comment_383099","dateInserted":"2023-06-29T14:47:23+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-29T18:08:21+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/BO5O2K273I0W\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-29T14:45:56+00:00","dateAnswered":"2023-06-29T14:43:11+00:00","acceptedAnswers":[{"commentID":383094,"body":"
Does your company use Single Sing-On? There were some updates that took affect yesterday. I wonder if maybe that is affecting things since it seems to be an issue with being part of the company's account.<\/p>
<\/p>
