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:

{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.