Why doesn't this SUMIFS working?

Dano

I get #unparseable.

 

=SUMIFS(Effort Hrs:Efford Hrs,Assignee:Assignee,"Easton",Sprint Week:Sprint Week,"32")

Effort Hrs = Hours worked

Assignee = the person

Sprint Week = the wee it is done

 

Javed Hassan

In your formula, it says "Efford Hrs". I'm not sure if that's a typo in the forum, or a type in the formula itself. If it's in the formula, that would likely cause the issue.

JoeC.

To follow up on what Javed said, because of the space in the column name, you need to use the syntax, [Effort Hrs]:[Effort Hrs].

Andrée Starå

Great catch Joe!

J. Craig Williams

Same with [Sprint Week].

In general, spaces, special characters, column names that end in numbers all require the [] brackets.

I tend to use [columname] regardless of whether it needs it or not. Smartsheet's editor will remove them if they are not needed.

Craig

Dano

Thanks, great stuff.

See attached image, it still doesn't work

 

D...

 

JoeC.

You still have a syntax problem...it must be [Effort Hrs]:[Effort Hrs] <--- notice the inner brackets.

Dano

Thanks much...