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?
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.
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
@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?
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.
Is it possible to add a pattern (e.g., diagonal lines) to a dashboard chart?
I have a sheet that tracks employees certifications. I'd like to setup a single automation that runs weekly to alert the employee when the expiration date is within 180, 90, 60 and 30 days away. I'd prefer that the 180 day alert only be sent monthly until the 90 day date is hit, then weekly. I'd like the message sent to…
Our builders submit dates at each critical stage. I need to write a formula to show what stage the house is in by the looking at the latest date submitted. Any thoughts to what function i should use. Trying to give the last column "Stage of Job", an answer of Slab, Frame, Cabinets or Final CO, based on the latest date…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.