Help

Trying to translate Template ID's to Words

Topic Labels: Formulas
751 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Liesbet_De_Rouc
4 - Data Explorer
4 - Data Explorer

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!

1 Reply 1

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"
)