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

Khan Z

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?

Amit Wadhwani

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.

Khan Z

@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

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/