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?
GCavin
(Gilles Cavin - Reinventing Formulas in monday.com)
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.