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!
Trying to translate Template ID's to Words
This topic has been closed for replies.
+35You 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"
)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.