Prohibit a cell from being marked as complete

rshelnutt
rshelnutt ✭✭✭✭
inSmartsheet Basics

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

Capture.JPG


Tags:
· Share on Facebook Share on Twitter

Answers

  • Paul Newcome
    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.

    10 xviz.com

    · Share on Facebook Share on Twitter
  • rshelnutt
    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

    · Share on Facebook Share on Twitter
  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Happy to help.️

    10 xviz.com

    · Share on Facebook Share on Twitter

Categories

You can skip the collect and just use MAX():<\/p>

=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":"

Hey @Michael Batt<\/a> <\/p>

Under the attachment Tab in a sheet you can select All<\/strong> to see all the attachments in the sheet and scroll through them, however you're right, PDFs show a PDF icon versus a thumbnail like a JPEG:<\/p>

\n
\n \n \"Screenshot<\/img><\/a>\n <\/div>\n<\/div>\n

Please 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>

Cheers,<\/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":[]},{"discussionID":110815,"type":"question","name":"If date range includes a Friday - check a box","excerpt":"I have a sheet with a start date and an end date. I would like a checkbox column to be checked if that date range includes a Friday. Any ideas on how I would do that? Thank you in advance. Jennifer","snippet":"I have a sheet with a start date and an end date. I would like a checkbox column to be checked if that date range includes a Friday. Any ideas on how I would do that? Thank you in…","categoryID":321,"dateInserted":"2023-09-26T19:33:10+00:00","dateUpdated":null,"dateLastComment":"2023-09-27T16:00:30+00:00","insertUserID":155497,"insertUser":{"userID":155497,"name":"JSpears","url":"https:\/\/community.smartsheet.com\/profile\/JSpears","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BgDcwSo-92c!7zlc-6IqQLs!HEmr4KUqqxd","dateLastActive":"2023-09-27T16:18:32+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-09-28T14:31:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":53,"score":null,"hot":3391590220,"url":"https:\/\/community.smartsheet.com\/discussion\/110815\/if-date-range-includes-a-friday-check-a-box","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110815\/if-date-range-includes-a-friday-check-a-box","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":110815,"commentID":397260,"name":"Re: If date range includes a Friday - check a box","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/397260#Comment_397260","dateInserted":"2023-09-27T16:00:30+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-09-28T14:31:43+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-09-27T15:24:45+00:00","dateAnswered":"2023-09-27T14:19:17+00:00","acceptedAnswers":[{"commentID":397230,"body":"

Give this a try:<\/p>

=IF(OR(WEEKDAY([Start Date]@row) = 6, WEEKDAY([End Date]@row) = 6, [End Date]@row > [Start Date]@row + (6 - WEEKDAY([Start Date]@row)) - IF(WEEKDAY([Start Date]@row) < 6, 7, 0) + 7), 1)<\/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":254,"urlcode":"formulas","name":"Formulas"}]}],"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":5112,"limit":3},"title":"Trending in Smartsheet Basics","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending in Smartsheet Basics

  • MAX COLLECT for dates in a row

    I have a certification that requires a few lessons to be fully certified. Each lesson has a completion date in it's own column and a date column for when they become fully certified. So, if there if one training is missing a completion date they are not considered fully certified. My need is to be able to collect the max…

  • PDF我con / Thumbnail in the row?

    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…

  • If date range includes a Friday - check a box

    I have a sheet with a start date and an end date. I would like a checkbox column to be checked if that date range includes a Friday. Any ideas on how I would do that? Thank you in advance. Jennifer

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video