How to Trigger Workflow

Andrea Westrich

I have a sheet that contains a status field that could be one of the following values:

Closed, Pending, Active, Failed

I'd like to trigger a workflow for an update specifically when the Status changes from Active to Pending. Any ideas on how to do that?

Thanks

Mark Cronk

Good evening @Andrea Westrich ,

Create a new workflow with a trigger "When rows are added or changed". Select when [status] changes to "Pending". Build the action you want to occur. Should be straight forward.

Work?

Mark

Andrea Westrich

@Mark Cronk That would work, but I only want the action to occur if it changes from Active to Pending. Not if it changed from blank to pending or Closed to pending, etc. Make sense?

Mark Cronk

Hi Andrea,

Now I understand, but I don't have a solution four you. Lots of creative people in the Community. I'm curious to see what ideas get posted.

Mark