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”
Thanks
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):
https://www.make.com/en/register?pc=msquare
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!
Mark
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,
Mark
Thanks so much, don’t know what i was thinking!
