Help

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
Jump to Solution
329 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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(...).

See Solution in Thread

1 Reply 1

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(...).