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
-
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.
-
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
-
Happy to help. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives