Automatic Formatting between 2 Columns
Hello,
Can I have a Status Cell (Drop-Down List) be automatically updated to "Complete" when a "% Complete" column is changed to 100%?
Thanks!
Best Answer
-
jpaul ✭✭✭✭Good afternoon Claire,
You can easily accomplish this with a sheet automation. Please see screen shot for the set-up.
Answers
-
jpaul ✭✭✭✭
Good afternoon Claire,
You can easily accomplish this with a sheet automation. Please see screen shot for the set-up.
-
Thank you!
Help Article Resources
Categories
Try removing the closing parenthesis after the 42.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":110844,"type":"question","name":"Vendor management and ID #","excerpt":"I would like to assign unique vendor IDs in a database according to vendor type (independent column) and sequential numbering. Screenshot of what I am trying to produce below. I have found that the Auto Number column type only accepts a fixed prefix and thus cannot populate different prefixes based on Vendor Type along…","snippet":"I would like to assign unique vendor IDs in a database according to vendor type (independent column) and sequential numbering. Screenshot of what I am trying to produce below. I…","categoryID":322,"dateInserted":"2023-09-27T10:15:28+00:00","dateUpdated":null,"dateLastComment":"2023-09-27T12:47:34+00:00","insertUserID":161575,"insertUser":{"userID":161575,"name":"LGraf","url":"https:\/\/community.smartsheet.com\/profile\/LGraf","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-27T12:47:41+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":161575,"lastUser":{"userID":161575,"name":"LGraf","url":"https:\/\/community.smartsheet.com\/profile\/LGraf","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-27T12:47:41+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":17,"score":null,"hot":3391629782,"url":"https:\/\/community.smartsheet.com\/discussion\/110844\/vendor-management-and-id","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110844\/vendor-management-and-id","format":"Rich","lastPost":{"discussionID":110844,"commentID":397197,"name":"Re: Vendor management and ID #","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/397197#Comment_397197","dateInserted":"2023-09-27T12:47:34+00:00","insertUserID":161575,"insertUser":{"userID":161575,"name":"LGraf","url":"https:\/\/community.smartsheet.com\/profile\/LGraf","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-27T12:47:41+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":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/2R63S9Z7G5M2\/screenshot-2023-09-27-105524.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot 2023-09-27 105524.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-09-27T12:47:39+00:00","dateAnswered":"2023-09-27T11:37:40+00:00","acceptedAnswers":[{"commentID":397184,"body":"
