Sheet Summary Field - Count Value from Dropdown

josedimaculangan

What's wrong with this Formula? Getting an Invalid Ref

Jgorsich

change your {training account status} to [training account status]:[training account status]

Jgorsich

You deleted the "@cell," from your has() function, add that back in.

Jgorsich

change your {training account status} to [training account status]:[training account status]

josedimaculangan

@Jgorsich still not working…

Jgorsich

You deleted the "@cell," from your has() function, add that back in.

josedimaculangan

Perfect thank you so much! That worked.

josedimaculangan

@Jgorsich can you help me one more?

Our dashboard is almost complete - just need help with this formula. I need to summarize the project tasks assigned to Joint, Client, and IM that are Complete as a percentage. Can you assist?

Basically COUNT total tasks assigned to Joint/Client/IM that are COMPLETE divided by total tasks assigned to Joint/Client/IM

Jgorsich

@josedimaculangan - just so you understand the "why" of it (or in case someone else looks at this exchange); the curly brackets are used for named ranges, typically across sheets. Square brackets and the colon are used for ranges in the same sheet you are working in, with the left side of the colon being the start and the right side being the end. When both sides are just the name of the column, it applies to the whole column.

You may have seen formulas written similarly with NO brackets but with the colon - when the column name doesn't have any numbers or spaces or special characters, you can skip the brackets entirely, but they never hurt anything to add in.

josedimaculangan

I figured the other question out. Thanks again!

Jgorsich

@josedimaculangan Excellent - I just noticed that you asked it (and your image is coming through as broken).

For what it is worth, two different countifs() is what I'd have gone for there (countifs(everything plus complete)/countifs(everything EXCEPT complete), plus an error trap at the beginning to prevent a divide-by-zero error (iferror(formula,"")).