Multiple IF Statement

Hi there,

Anyone knows what is the correct formula if you want to display value based on the input value.

My idea is here

IF({Artist}=“Huge Jackman”,“012345”), IF({Artist}=“Oprah Winfrey”,“12345”), IF({Artist}=“Celine Dion”,“55024”)

I want to automate if for example if the exact name is matched in the Artist column (text) it would display the corresponding ID number.

@jsgamba

It might be better to create a separate board then use connect board and a mirror column. To use a formula this is what I would do:

IF({Artist} = "Huge Jackman", "012345", "") &
IF({Artist} = "Oprah Winfrey", "12345", "") &
IF({Artist} = "Celine Dion", "55024", "")

OR…

SWITCH({Artist},
"Huge Jackman", "012345",
"Oprah Winfrey", "12345",
"Celine Dion", "55024",
"")

Jim - The Monday Man (YouTube Channel)
What is Make & How can it help you with monday?
We Create Custom Solutions - Your Make or Ours
Schedule a 1-on-1 Tutorial Session (for monday, Make or Google Sheets)