Help

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

Topic Labels: Formulas
Solved
Jump to Solution
975 1
cancel
Showing results for 
Search instead for 
Did you mean: 
AandD_Tull
5 - Automation Enthusiast
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
Zollie
10 - Mercury
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(...).

See Solution in Thread

1 Reply 1
Zollie
10 - Mercury
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(...).