#UNPARSEABLE error

Can anyone help identify the problem here? It is a simple formula to sum the numbers if 2 conditions are met and works perfectly in excel but Smartsheet keeps giving this error.

=SUMIFS({DHR Team Time off Planner 2023 Range 1}, {DHR Team Time off Planner 2023}, [DHR Team Member]@row, {DHR Team Time off Planner 2023 Range 3},"vacation"}})

Could it be because the name match is a drop down string value?

Find more posts tagged with

Accepted answers

Andrée Starå

Hi @Kash

I hope you're well and safe!

Try something like this.

=SUMIFS({DHR Team Time off Planner 2023 Range 1}, {DHR Team Time off Planner 2023}, [DHR Team Member]@row, {DHR Team Time off Planner 2023 Range 3},"vacation"

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

All comments

Andrée Starå

Hi @Kash

I hope you're well and safe!

Try something like this.

=SUMIFS({DHR Team Time off Planner 2023 Range 1}, {DHR Team Time off Planner 2023}, [DHR Team Member]@row, {DHR Team Time off Planner 2023 Range 3},"vacation"

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

Kash

Hi Andrée,

Thank you I am very well and happy since I have been at it for a few hours and it worked :D

Can't believe it was just the parenthesis issue, excel would usually just remove extras but here as well I did try a few combinations. Anyway, thanks it works perfectly now!

Hope you are staying well and safe during today's snow storm as well.

Andrée Starå

@Kash

Excellent!

Happy to help!

I'm well and happy too, but no snow here.

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Kash

Another year and still stuck with the same issue when creating a new sheet for the year. Anyone has a solution?

=SUMIFS({DHR Team Time off Planner 2024 Range 6}, {DHR Team Time off Planner 2024}, (Employee Name) @row, {DHR Team Time off Planner 2024 Range 2}, "vacation"

Genevieve P.

Hey @Kash

When you're referencing a column name in a current sheet, you'll need to use [square] brackets. Try this:

=SUMIFS({DHR Team Time off Planner 2024 Range 6}, {DHR Team Time off Planner 2024}, [Employee Name]@row, {DHR Team Time off Planner 2024 Range 2}, "vacation")

Cheers,

Genevieve

Kash

Heyy Genevieve, thanks for the help. I spent ours on it just to realize it was the header name mismatch :/ lol just worked and it adds so much excitement to the day!!

Enjoy!

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.