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

AppSheet AppSheet Q&A
,
1

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

2

IFS

1 Like
3 
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

2 Likes
4

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 :slightly_smiling_face: thank you Sir

1 Like