Skip to content
  • Try Smartsheet

    • Formulas and Functions

    Formulas and Functions

    Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

    #UNPARSEABLE error

    ✭✭✭
    in Formulas and Functions

    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?

    · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Best Answer

    • Community Champion
      Answer ✓

      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!

      SMARTSHEET EXPERT CONSULTANT & PARTNER

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

      W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

      Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

      · Share on FacebookShare on Twitter

    Answers

    • Community Champion
      Answer ✓

      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!

      SMARTSHEET EXPERT CONSULTANT & PARTNER

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

      W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

      Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

      · Share on FacebookShare on Twitter
    • ✭✭✭

      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.

      · Share on FacebookShare on Twitter
    • Community Champion

      @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!

      SMARTSHEET EXPERT CONSULTANT & PARTNER

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

      W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

      Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

      · Share on FacebookShare on Twitter
    • ✭✭✭

      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"

      · Share on FacebookShare on Twitter
    • Employee

      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

      Need more information? 👀 | Help and Learning Center

      こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions

      · Share on FacebookShare on Twitter
    • ✭✭✭

      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!

      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Help Article Resources

    Create and edit formulas in Smartsheet

    Formula combinations for cross sheet references

    Smartsheet functions list

    Quick Links

    Categories

    Want to practice working with formulas directly in Smartsheet?

    Check out the Formula Handbook template!

    Trending in Formulas and Functions