Automation to compare two columns and change the status of the item

Is there a way to create an automation that will compare the values in two columns to one another and if they differ, change the status of the item? Example:

Column 1 - installed software version
Column 2 - available software version

If column 2 does not match column 1 set status of item to “out of date”


Hi @John_17 ,

you can use Make to create an automation that compares values in two columns and changes the status of an item if they differ.

As a complimentary, here is our magic link to get 1 Month Pro plan free (10,000 operations):

For further implementation details kindly contact us:
MSquare Support
Visit us here
Youtube Channel

Hi @John_17 - you can use General Caster to compare the two columns and cast the result to a status.

The other option, would be to use a simple formula column with the following:
IF({installed software version} = {available software version}, “”, “Out of Date”)

Then use conditional coloring to set the background of the formula to a different color based on the result (making it appear like a Status column).

Hope this helps!

Excellent, that formula worked for what I wanted

HI @John_17 can I ask how to do this with Gen Cast? I cannot find a recipe to compare two columns. Thanks!

Hi @Sara413 - just a simple IF statement would make it work.

IF ({Column1} = “Yes”, “Status1”, “Status 2”)

Hope this helps,

:woman_facepalming: Thanks so much, don’t know what i was thinking!

1 Like