Automation (how to?): IF a dropdown gets a certain value, THEN set the same dropdown to a different value

monday Apps & Developers
, ,
1

I am looking for a way to accomplish what looked like a simple automation:

  • IF a dropdown column is set to Value A
  • THEN change the same dropdown column to Value B.

But, I have found no way to do this.
I can set the trigger just fine: “When column changes” → “And only if Dropdown “Brand” meets condition XX”.

But I cannot set the desired action.
I can select “Then clear column” or “Then set number to”.
But I need something like “Then change column” or “Then update column value”, where I can subsequently select Dropdown “Brand” and choose another dropdown option to set.

Is it really only Status columns that can be set to specific values as automation actions? Or am I missing the way to do it with dropdown columns as well?

Overall, I need to solve an issue of when an item is created in my Airtable base, and then automatically created in Monday as well. Words in certain fields in Airtable are then created in Monday with a random sequence of letters and numbers, which I then need Monday to automatically change to the proper words.

2

Hi Kim,

Indeed, there is no automation to set a dropdown column to a specific value.

You could do it with the Advanced Formula Booster, a 3rd-party app that allows to create formulas that cast their results to any type of columns.

So you could have “When column changes” → “And only if Dropdown “Brand” meets conditionXX” then “Run this formula” where the formula would be:

{Dropdown]=“ZZZ”

3

Hey @KimEtzerodtThe1st
You can do that with just a simple General Caster integration.