Formula correcta?

Platform discussions
1

Hola una pregunta sabrán como puedo usar las formulas, he probado utilizar la siguiente formula SWITCH({Salón#Labels}, “Marques”, V, “Solar de Conin”, W, “Fundador de Conin”, X, “Alcazar de Conin”, Z, “Real de Conin”, Y).

Lo que quiero es que cuando se selecciones algún nombre de esos salones, me los cambie por las letras correspondientes. Pero no me esta funcionando esta formula. Alguien sabe que estoy haciendo mal?

2

@JorgeGarcia

I don’t really speak Spanish. But, here goes:

I see 2 possible issues:

  1. The letters must also be in quotes.
  2. You might need to change the order of the pairs.

One of these should work:

SWITCH({Salón#Labels}, "Marques", "V", "Solar de Conin", "W", "Fundador de Conin", "X", "Alcazar de Conin", "Z", "Real de Conin", "Y")

OR…

SWITCH({Salón#Labels}, "V", "Marques", "W", "Solar de Conin", "X", "Fundador de Conin", "Z", "Alcazar de Conin", "Y", "Real de Conin")

Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: Column Total in monday.com Formulas? YES!!!
Check out our monday apps, now in beta: The Monday Man Apps

1 Like
3

thanks, the first option was the one that served me

4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.