#unparseable

#unparseable

edited 12/09/19 in Using Smartsheet

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" ])

Comments

  • 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") )

  • Mike WildayMike 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. :) 

Sign In or Register to comment.