Formula IF when dropdown label is something

Platform discussions
, , ,
1

Hi, I am trying to build a formula that when dropdown is = to something, set this number, if is another something, set this number. But It doesn’t work. Basically is a list of vendors that each of they have a specific vendor number, so I want that when a select the vendor in my dropdown list, the formula assign the correct vendor number.

IF({Proveedor#Labels}=“GASCON CORPORATIVO & NOTARIA, S.C.”,“4443”)
IF({Proveedor#Labels}=“NOTARIA Y CORREDURIA 35, S.C.”,“326”)

Can someone help me please?

2

Hi Valentina,

Try:

IF({Proveedor}=“GASCON CORPORATIVO & NOTARIA, S.C.”,“4443”, IF({Proveedor#Labels}=“NOTARIA Y CORREDURIA 35, S.C.”,“326”))

What if we could break free of the Formula column? and write formulas that update any type of columns? What if a formula could update multiple columns at once? This is possible with the Advanced Formula Booster app.

1 Like
3

I worked perfect!! thank you!!

4

HI Gilles,

suppose I want a formula for the case that if the proveeder column is empty, the result is “no proveeder” and when there is a proveerder, the result is “proveeder available”

how does the formula look like then?

IF({Proveeder}=“”,“no proveeder”;“proveeder available”) does not work

5

Hi @SamV,

You have a semi-colon in your formula between “no proveeder” and “proveeder available”. Replace it with a comma and it should work.

Looking for a simpler way to write complex formulas? Check out the Advanced Formula Booster at https://mdboosters.com. It’s a convenient third-party app that simplifies formula writing. With it, you can spread your formulas across several lines, utilize variables, and access dozens of functions not found in the standard formula column.

6

thx Gilles for quick reply

indeed a syntax error, but it doesn’t do the job in my own environment

let me show you what I did:

I used this formula in column “Check Boxset is empty”:

if({Boxset Categorie}=“”,“no boxset”,“boxset available”)

the column boxset is a label with these possible values:

image

but the resulkt in that column is for all of my items = “boxset available” whatever the value in column Boxset Categorie:

image
image663×560 55.4 KB

7

@SamV,

For testing purposes, replace your current syntax by simply {Boxset Categorie} and you’ll see that the grey label without text has a value. In my case, it is “Empty”. Might depend on your local version of monday.

Then adjust your syntax to:

IF({Boxset Categorie}="Empty","no boxset","boxset available")

Want to take your formulas to the next level? Try the Advanced Formula Booster, the app that reinvents formulas in monday.

  • Create formulas without using the Formula column (and avoid its limitations)
  • Build formulas involving data from the previous item, the next item, the sub-items, the parent item, even items in the same group or the same board.
  • In one formula, update multiple columns from multiple items.

Check our blog for real use cases.

8

thx also for this hint

it works!

(also “Empty” in my version)