Prohibit a cell from being marked as complete

rshelnutt

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

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

Happy to help. 👍️