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
May 11, 2021 05:41 AM
Hello!
I’m trying to use the nested IF function to return a specific piece of text per code that I enter (7 codes in total). I have tried to use both IF and SWITCH, and they seam to work for the first one or two and then I can’t get any further.
For example, these are the conditions I would like to have met:
IF{Indicator}=1, “A”
IF{Indicator}=2, “B”
IF{Indicator}=3, “C”
IF{Indicator}=4, “D”
IF{Indicator}=5, “E”
IF{Indicator}=6, “F”
IF{Indicator}=7, “G”
The letters (A-G) are just substitutes for text I would like to include. It’s one sentence per IF function - could it be a length issue?
May 11, 2021 11:33 AM
I don’t know of any character limit for formulas so I don’t think that would be the issue. A SWITCH()
function would look like this:
SWITCH(
{Indicator},
1, "A",
2, "B",
3, "C",
4, "D",
5, "E",
6, "F",
7, "G"
)