Trying to translate Template ID's to Words

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

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.