Prohibit a cell from being marked as complete
Hi everyone,
Does anyone know how you can keep someone from completing a line item? I have a sheet where I ask for a resolution to an issue and some users are marking the item as complete without providing the details of the resolution. I would like to block them from the cell until data is entered into the resolution cell. Does this make sense.
I have attached a photo of the portion of the sheet that is in question.
Thanks in advance!
Regina
Answers
-
Paul Newcome ✭✭✭✭✭✭That is not going to be possible. You are going to need to use one (or a combination) of a few different options for flagging and alerting.
You can use conditional formatting to highlight the Resolution cell if it is blank and the Status equals complete.
You can send an update request to the user based on those same conditions prompting them to fill it in.
You can use a change cell automation to change the Status back to In Progress.
-
rshelnutt ✭✭✭✭
Hi Paul,
I think your automation suggestions will work. I will build that into my template when I update it next.
Thanks!
Hope to see you at Engage. This will be my first, so I am looking forward to learning from you and everyone else there.
Regina
-
Paul Newcome ✭✭✭✭✭✭
Categories
=IF([Fully Certified]@row = \"Yes\", MAX([Train Date - Blower]@row, [Train Date - Broom]@row, [Train Date - Chem]@row), \"//www.santa-greenland.com/community/discussion/109469/\")<\/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":110767,"type":"question","name":"PDF Icon \/ Thumbnail in the row?","excerpt":"Hi, I'm sure its a big use of smart sheet, I use various registers to store documents especially drawings. Each row is a drawing or document, if there are different Issues I use the upload new version. There are the Ref#, Issue#, description and drawn date columns etc. The drawing is a pdf attachment. However you can not…","snippet":"Hi, I'm sure its a big use of smart sheet, I use various registers to store documents especially drawings. Each row is a drawing or document, if there are different Issues I use…","categoryID":321,"dateInserted":"2023-09-26T10:55:25+00:00","dateUpdated":"2023-09-26T11:49:30+00:00","dateLastComment":"2023-09-28T11:22:19+00:00","insertUserID":138065,"insertUser":{"userID":138065,"name":"Michael Batt","url":"https:\/\/community.smartsheet.com\/profile\/Michael%20Batt","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T13:27:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":91566,"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-09-28T15:15:58+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":22,"score":null,"hot":3391626464,"url":"https:\/\/community.smartsheet.com\/discussion\/110767\/pdf-icon-thumbnail-in-the-row","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110767\/pdf-icon-thumbnail-in-the-row","format":"Rich","lastPost":{"discussionID":110767,"commentID":397383,"name":"Re: PDF Icon \/ Thumbnail in the row?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/397383#Comment_397383","dateInserted":"2023-09-28T11:22:19+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-09-28T15:15:58+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,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-09-28T12:05:59+00:00","dateAnswered":"2023-09-28T11:22:19+00:00","acceptedAnswers":[{"commentID":397383,"body":"
![\"Screenshot](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/FQIXXT6IRJ6S\/screenshot-2023-09-28-at-12-18-26.png\")
<\/img><\/a>\n <\/div>\n<\/div>\nPlease submit your feature request of having the PDF image to appear in the Attachment tab to the Product team by creating an Idea Post<\/strong> in the Smartsheet Product Feedback and Ideas topic<\/a> here in the Community. This will allow other users to vote on your enhancement idea!<\/p>
