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