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

# Gahh more formula issues

Topic Labels: Formulas
Solved
282 2
cancel
Showing results for
Did you mean:
6 - Interface Innovator

Guys you are always so amazing, I have tried everything I can think of I have a table with rows that represent different branches and then there’s 15 columns representing a variety of different areas all with options red, amber, green - i would really like to have a colum that counts how many “red” responses there are, how many amber etc but I cannot work out how to do that - any ideas

1 Solution

Accepted Solutions
14 - Jupiter

If I’m understanding your setup properly, I think you can do something like this:

Total Red Responses

``````IF({First Option Field} = "red", 1) +
IF({Second Option Field} "red", 1) +
IF({Third Option Field} = "red", 1) ...etc
``````

Total Amber Responses

``````IF({First Option Field} = "amber", 1) +
IF({Second Option Field} = "amber", 1) +
IF({Third Option Field} = "amber", 1) ...etc
``````

Just continue to add all 15 fields you have with a “+” for each new one you add. And do the same in a new formula field for “green” responses as well.

2 Replies 2
14 - Jupiter

If I’m understanding your setup properly, I think you can do something like this:

Total Red Responses

``````IF({First Option Field} = "red", 1) +
IF({Second Option Field} "red", 1) +
IF({Third Option Field} = "red", 1) ...etc
``````

Total Amber Responses

``````IF({First Option Field} = "amber", 1) +
IF({Second Option Field} = "amber", 1) +
IF({Third Option Field} = "amber", 1) ...etc
``````

Just continue to add all 15 fields you have with a “+” for each new one you add. And do the same in a new formula field for “green” responses as well.

6 - Interface Innovator

Thanks you are a star!