Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

# Trying to create score based on a string of checkboxes (SUM based on IF?)

Topic Labels: Formulas
Solved
329 1
cancel
Showing results for
Did you mean:
5 - Automation Enthusiast

I am trying to create a priority score for a team travel destination based on a series of checkboxes. This is what I tried:

SUM(IF({1 Must Do}5,0),(IF({2 high on list}4,0),(IF({3 would like to do}3,0),(IF({4 maybe if in the area}2,0))

This isn’t being accepted. Any help appreciated.

1 Solution

Accepted Solutions
10 - Mercury

Looks like there are some typos. Try spreading out and indenting your code so they’re easier to spot. Each argument should be separated by a comma and every opening parenthesis should have a corresponding closing parenthesis.

Here’s what it looks like spread out. Note, this code still has the original errors in it.

``````SUM(
IF(
{1 Must Do}
5,
0
),
(IF(
{2 high on list}
4,
0
),
(IF(
{3 would like to do}
3,
0
),
(IF(
{4 maybe if in the area}
2,
0
)
)
``````

What are the ‘Typos’ (aka syntax errors)

(1) There are missing commas after the first argument in the IF blocks. So it should be:

`IF(param1,param2,param3)`
Not: `IF(param1param2,param3)`

(2) Extra opening parenthesis before a few IF blocks, so it should be:

`IF(...)`
Not: `(IF(...)`.

10 - Mercury

Looks like there are some typos. Try spreading out and indenting your code so they’re easier to spot. Each argument should be separated by a comma and every opening parenthesis should have a corresponding closing parenthesis.

Here’s what it looks like spread out. Note, this code still has the original errors in it.

``````SUM(
IF(
{1 Must Do}
5,
0
),
(IF(
{2 high on list}
4,
0
),
(IF(
{3 would like to do}
3,
0
),
(IF(
{4 maybe if in the area}
2,
0
)
)
``````

What are the ‘Typos’ (aka syntax errors)

(1) There are missing commas after the first argument in the IF blocks. So it should be:

`IF(param1,param2,param3)`
Not: `IF(param1param2,param3)`

(2) Extra opening parenthesis before a few IF blocks, so it should be:

`IF(...)`
Not: `(IF(...)`.