Notification only show changed cells
I am sure this should be possible but can't find any direct reference to it:
I have set up notifications and approvals in a workflow as consequences of a request for updates. I would like the notifications (and/or approvals) sent after that update to include only the cells that were updated, in exactly the same way that it is reported in sheets activity log?
Additionally: to encourage the original request for changes or confirmation there is a field for them to complete... "No Changes/Yes changes", Ideally this field would be "required" to force an answer (and therefore enable a trigger, but because it can't be set as required it is an imperfect solution. I've worked around this issue by adding the "Modified By" column and testing for this value, but it seems like it's putting an unneccessary burden on the background testing.
Appreciate any thoughts.
Comments
-
Hi,
Unfortunately, it's not possible at the moment to show fields dynamically, but it's a great idea! You can, however, change the what fields should show in Alerts, Reminders, Update Requests, and Approval Requests for the specific Action in the Workflow.
Unfortunately, it's not possible either to make a field required at the moment, but that is also a great idea! As a workaround, you could have another Update Request automatically sent asking them to fill in the required fields.
Please submit an Enhancement Request when you have a moment.
Hope that helps!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
It seems weird, but when I set the notification to be sent to our Microsoft Teams chat, it only sends the updated field/cells!! So the functionality is there just not for email notifications or approvals?
-
The Alerts/Notifications behave differently depending on the if they originate from a request or something else so yes, as far as I know, that's correct.
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 458 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives