nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

Welcome!

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

Find more posts tagged with

Formulas

Project Management

Comments

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...

SUMIFS Error.jpg

JoeC.

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

Dano

Thanks much...

Sign in to join the conversation!

Quick Links

Trending discussions

How to calculate % of empty cells in a sheet?
Looking to calculate the % of empty cells in a sheet for all rows that have data, with the intention of excluding any rows beyond my last row. I'd like to use this to motivate relevant stakeholders to completely populate the columns. Thank you.
unable to get the values via Sumifs formula
So here what I'm trying, I have multiple solution and status for all. Trying to get the total net worth value of order based on solution + individual status. Let's say I want to capture the total revenue for Centralised Inventory with all different status as below: I tried with Sumifs but it's not calculating all values.…
Formula Question
I have an Action Log and in the log we have a column that identifies the different projects our team leads. There is also a Workstream column, which identifies what workstream is responsible for getting the answer. There can be more than one answer, so we have a dropdown and if multiple workstreams are responsible for the…