Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Trying to translate Template ID's to Words

Topic Labels: Formulas
130 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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