Conditional Formatting if Calculated
Greetings, yes, here'sanotherpost about conditional formatting. I swear that I have searched and cannot find the answer to this, so...
I have some date fields that I've calculated based on another (30 days after X date). I'd like to automatically format these calculated cells so I can instantly see which ones are calculated vs have a date manually entered.
Any ideas?
Thanks!
Comments
-
Andrée Starå ✭✭✭✭✭✭Hi John,
不幸的是,正如far as I know, it's not possible at the moment, but it's a great idea!
Please submit an Enhancement Request when you have a moment.
有一个很好的一天!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå| Workflow Consultant / CEO @WORK BOLD
W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
-
Thanks, Andrée. I'll submit the request.
-
Andrée Starå ✭✭✭✭✭✭
Happy to help!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå| Workflow Consultant / CEO @WORK BOLD
W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
Categories
I got it. Change the Starting number to the number you want for a new row. Hope this works.<\/p>
![\"Screenshot_20230803-201230.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/NGLGUBT5AB4R\/screenshot-20230803-201230.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
<\/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":108444,"type":"question","name":"Update Request Automation not sending to free users despite \"Unrestricted\" Automation permissions?","excerpt":"I have an automated \"Update Request\" workflow set up on a sheet to send to contacts in a cell, and I'm getting a an error message saying that this email is not being notified, and that I need to change the Automation permissions to a less restrictive setting. The email address is for under our work domain, so that…","snippet":"I have an automated \"Update Request\" workflow set up on a sheet to send to contacts in a cell, and I'm getting a an error message saying that this email is not being notified, and…","categoryID":321,"dateInserted":"2023-08-02T21:11:55+00:00","dateUpdated":null,"dateLastComment":"2023-08-03T10:22:21+00:00","insertUserID":162989,"insertUser":{"userID":162989,"name":"Asher_Schulz","url":"https:\/\/community.smartsheet.com\/profile\/Asher_Schulz","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-03T14:10:54+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-08-03T14:23:13+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":25,"score":null,"hot":3382070656,"url":"https:\/\/community.smartsheet.com\/discussion\/108444\/update-request-automation-not-sending-to-free-users-despite-unrestricted-automation-permissions","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108444\/update-request-automation-not-sending-to-free-users-despite-unrestricted-automation-permissions","format":"Rich","tagIDs":[334,510],"lastPost":{"discussionID":108444,"commentID":388657,"name":"Re: Update Request Automation not sending to free users despite \"Unrestricted\" Automation permissions?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/388657#Comment_388657","dateInserted":"2023-08-03T10:22:21+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-08-03T14:23:13+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/MDVV8IY3LHSE\/delivery-errror-message.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"delivery errror message.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-03T14:07:33+00:00","dateAnswered":"2023-08-03T10:22:21+00:00","acceptedAnswers":[{"commentID":388657,"body":"
Hi @Asher_Schulz<\/a> & @Sarah Donnelly<\/a> <\/p> We received reports of this block and notification happening (even when the restriction permissions were set correctly to \"unrestricted\") if one of the emails that the workflow is sending to does not have a Smartsheet account. This has been fixed and the notifications should be correctly sent to those individuals moving forward.<\/p> If this does not describe your issue, please keep following up with Support, providing them with as much context and details as possible!<\/p> Thank you,<\/p> Genevieve<\/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"},{"tagID":510,"urlcode":"email-notifications","name":"Email Notifications"}]}],"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":4911,"limit":3},"title":"Trending in Smartsheet Basics","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
