#unparseable

dcharnin
dcharnin ✭✭
edited 12/09/19 in Smartsheet Basics

Hello All,

I am trying to sum to condition together from another sheet. I am looking to sum hour estimates when sprint name "01 2019" and Account "US Professional Services". I am able to get it to calculate on the first condition but when I am the second condition, I get  #unparseable

Here is the formula. 

=SUMIFS({Adient Backlog Range 1}, {Adient Backlog Range 2}, "01 2019", [{Adient Backlog Range 3}, "US Professional Services" ])

· Share on FacebookShare on Twitter

Comments

  • McMinski
    McMinski ✭

    Hi dcharnin,

    I am not 100% sure if I get your question right, but when using text you have to make a comparison. Something like this:

     

    =SUMIFS({Adient Backlog Range 1}, {Adient Backlog Range 2}, "01 2019", (@cell= "US Professional Services") )

    · Share on FacebookShare on Twitter
  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    Try using your original formula but remove the brackets surrounding your added argument.

    =SUMIFS({Adient Backlog Range 1}, {Adient Backlog Range 2}, "01 2019", {Adient Backlog Range 3}, "US Professional Services")

    See if that works. :) 

    · Share on FacebookShare on Twitter

Categories

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video