Skip to main content

Hi there,

Not sure if anyone can help me out on how to write the following formula:

I have a column with Template ID’s that should be translated to what type of Template they are.

I assume i need to write an IF template ID = 1 2 or 3 then show ‘thisword’ and if template ID = 4 5 or 6 then show ‘thatword’ but i have no idea how to write that formula. Im new to this so any help would be hugely appreciated.

Looking forward to solving this!

You could use a switch statement:


SWITCH(

{Template ID},

1, "This word",

2, "This word",

3, "This word",

4, "That word",

5, "That word",

6, "That word"

)

Reply


Terms & Conditions