Unparseable Error

stratman

Good day Smartsheet Team,

Getting an unparseable error on this formula:

=IF($Name@row <> "",(SUMIFS({Expense}, {Period},1, {Type}, OR(@cell = "RES602782", @cell = "RES602497")),"")

Trying to pull in all expenses from period 1 that have a type of RES602782 and RES602497.

Probably been looking at it too long but can't seem to get it parse. Thanks.

Mark.poole

@stratman

Right away with out looking into it too much. You have a syntax error. SUMIFS does not work with OR and AND statements. Instead you would have to do two separate formulas and add them together.

=IF(Name@row <> "", (SUMIFS({Expense}, {Period}, 1, {Type}, "RES602782") + SUMIFS({Expense}, {Period}, 1, {Type}, "RES602497")), "")

See if this fixes the problem for you.

Mark.poole

@stratman

Right away with out looking into it too much. You have a syntax error. SUMIFS does not work with OR and AND statements. Instead you would have to do two separate formulas and add them together.

=IF(Name@row <> "", (SUMIFS({Expense}, {Period}, 1, {Type}, "RES602782") + SUMIFS({Expense}, {Period}, 1, {Type}, "RES602497")), "")

See if this fixes the problem for you.

stratman

Yes. It. Does. Thanks Mark! Just starting to get used to the Excel > Smartsheet translation and this was very helpful and instructive.