Disable Comments for a single Sheet?
Is it possible to disable the use of comments on a single sheet? Or is there a way to get an alert to someone, perhaps sheet owner/admins or a special group when there is a comment added?
Sherry Fox
Business Process Analyst 3 | C5ISR Group | HII | Mission Technologies
EAP | Mobilizer | Automagician | Superstar | Community Champion Class of 2024
Core App Certified 🦊
NEW (Work) Profile: @SherryFox | OLD (Personal) Profile: @Sherry Fox
Connect with me on LinkedIn
Please Like ❤️, Vote Up ⬆️, Awesome 🤩, Insightful 🧐 any of my contributions that have provided value.
Best Answer
-
You can't disable comments altogether on a sheet, but you can manage comments by controlling permissions people have on the sheet - limit sharing to Viewer only. If people need to see and edit information, you can manage that through using the Dynamic View premium app (and uncheck the "Users can add comments" control) or set up a system of update or approval automations.
As realtes to alerting someone when a comment is added, …yes! You sure can. Build the trigger of automation to trigger when rows are added or changed - when a comment is added or changed. You can run a workflow as soon as it's triggered, or you can send periodic updates (hourly, etc.). Here's a bit more on Alert & Reminder automations:
Good luck!
If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!
Answers
-
You can't disable comments altogether on a sheet, but you can manage comments by controlling permissions people have on the sheet - limit sharing to Viewer only. If people need to see and edit information, you can manage that through using the Dynamic View premium app (and uncheck the "Users can add comments" control) or set up a system of update or approval automations.
As realtes to alerting someone when a comment is added, …yes! You sure can. Build the trigger of automation to trigger when rows are added or changed - when a comment is added or changed. You can run a workflow as soon as it's triggered, or you can send periodic updates (hourly, etc.). Here's a bit more on Alert & Reminder automations:
Good luck!
If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!
-
Thanks so much. I am new at my company, so I am not sure if we have Dynamic View premium app. And these users need the ability to edit, so View only access would not work. I will check if we have this Dynamic View.
And thanks for the Plan B. I always try to create a Plan B on every situation, as you never know what you will be faced with. Appreciate your help!
Sherry Fox
Business Process Analyst 3 | C5ISR Group | HII | Mission Technologies
EAP | Mobilizer | Automagician | Superstar | Community Champion Class of 2024
Core App Certified 🦊
NEW (Work) Profile: @SherryFox | OLD (Personal) Profile: @Sherry Fox
Connect with me on LinkedIn
Please Like ❤️, Vote Up ⬆️, Awesome 🤩, Insightful 🧐 any of my contributions that have provided value.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.1K Get Help
- 444 Global Discussions
- 142 Industry Talk
- 472 Announcements
- 5K Ideas & Feature Requests
- 83 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 489 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives