Identifying the owner of a row has changed and sending an alert

Hello

I have a risk register where each risk (row) has a specific owner (named contact). I want to trigger an alert (workflow) when that owner changes.

I've tried building a workflow, but it's triggering when any value in any cell changes.

How can I refine this to trigger only when the RIO Owner changes to a new value?

Find more posts tagged with

Workflows in Smartsheet

Accepted answers

All comments

Romano el Polako

Hey,

Have you tried to add a helper automated column "Modified by"

and set it up as one of the conditions?

Where Modified by is equal to: XYZ

Thanks,

Roman

Carina.C

@Romano el Polako I don't think that works in this use case. The first owner may edit the row to re-assign ownership to someone else, or a different user entirely could change the owner. I need a way of identifying that the owner value has changed to a new value.

Paul Newcome

Your existing automation should be working as expected. How are you currently populating that triggering column?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.