Notification only show changed cells

Notification only show changed cells

edited 12/09/19 in Using Smartsheet

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

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    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

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • 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?

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    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.

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

Sign In or Register to comment.