Display value "Tower" if column [Escalation Level] is Level 1 or Level 2 or Level 3

[agent_p]

So I'm trying to set the display value of a virtual column to "Tower" if one of my column [Escalation Level] is Level 1 or Level 2 or Level 3

"IM" if my column [Escalation Level] is Level 4 or Level 5

and "Executive" if my column [Escalation Level] is Executive

Hope you can help me guys

[dbaum]

IFS

[1minManager · Accepted solution]

IFS(
   [Escalation Level]="Executive","Executive",
   [Escalation Level]="Level 4","IM",
   [Escalation Level]="Level 5","IM"
)

https://support.google.com/appsheet/answer/10107912?hl=en

Simon, 1minMaanger.com 

[agent_p]

I'm not sure why I got some errors when pasted this on column formula but I was able to accomplish this after manually adding every detail via Data Explorer 🙂 thank you Sir