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.

Find more posts tagged with

Accepted answers

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.

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.