Alert or update if a column value is changed based on the column(primary column)

Options

Example - I've columns warehouse and route . I need to setup a notification or alert if the route had changed for a particular warehouse.

In this example , I need to send notification or alert for Test and PR103 as the previous values of route has changed for them.

can someone guide me as to how to do this?


Answers

  • Amit Wadhwani
    Amit Wadhwani ✭✭✭✭✭✭
    Options

    Hi Khan

    You can try creating an automation. The trigger should be set to "When rows are changed" so it only captures changes, and not new rows. You need to specify the condition when route changes to any value. A condition is required to trigger the alert only when the warehouse is either Test or PR103, and terminate otherwise. Here is a screenshot of the workflow for your reference.


    Best Regards

    Amit Wadhwani, Smartsheet Community Champion

    Smartsheet CoE, Ignatiuz Software, Exton, PA

    https://www.linkedin.com/in/amitinddr/


    Did this answer help you? Show some love by marking this answer as "Insightful 💡" or "Awesome ❤️" and "Vote Up ⬆️"

  • Khan Z
    Khan Z ✭✭
    Options

    @Amit Wadhwani , Thanks for the response , but the warehouse columns is something that keeps adding up and it's not feasible to update in conditions everytime its added. Basically what I'm trying to check is , for a warehouse , when an update to a new route(2nd update) happens , that's when there is need to send an alert . A cell to indicate this status also will help

  • Amit Wadhwani
    Amit Wadhwani ✭✭✭✭✭✭
    Options

    Hi Khan

    A workaround could be creating a secondary sheet. In your first sheet, create an auto number system column, that will act as unique identifier, and a workflow to copy every new row into the new sheet. To this point, your first and second sheets are the same.

    Now in your first sheet create a column "Original Value". Use INDEX/MATCH to fetch value of the Route from the second sheet. In the first sheet itself, create a third column which will compare both the values and then you can pretty much do everything including conditional formatting, alerts and update requests.

    Thanks

    Amit

    https://www.linkedin.com/in/amitinddr/

    Best Regards

    Amit Wadhwani, Smartsheet Community Champion

    Smartsheet CoE, Ignatiuz Software, Exton, PA

    https://www.linkedin.com/in/amitinddr/


    Did this answer help you? Show some love by marking this answer as "Insightful 💡" or "Awesome ❤️" and "Vote Up ⬆️"