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

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.

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

1 Like

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.