Count if formulas for assigned individuals

ionam

I have a work breakdown structure and I am trying to count the number of tasks allocated to contacts in the sheet.

The data is spread over multiple columns.

I have tried using this formula in a sheet summary -

=COUNTIF({Assigned to SME for initial build}, "Joe Bloggs") + COUNTIF({Assigned to: SME 2 (peer review)}, "Joe Bloggs")

But it is coming up with #invalid ref

Any suggestions please?

Find more posts tagged with

Accepted answers

Paul Newcome

I assumed you were referencing another sheet based on your use of {Cross Sheet References}. If the data is on the same sheet, you would reference a column by using

[Column Name]:[Column Name]

All comments

Mark.poole

@ionam Right click your sheet then go to manage references. Verify your reference names looking for any typos.

ionam

I dont have any references in there? Should I have

Paul Newcome

You are going to want to make sure you {Cross Sheet References} are set up properly:

https://help.smartsheet.com/articles/2482644-create-cross-sheet-references

ionam

Cross sheet references? All of the data I am using is in the one sheet. Why would I need to set up cross sheet references?

Paul Newcome

I assumed you were referencing another sheet based on your use of {Cross Sheet References}. If the data is on the same sheet, you would reference a column by using

[Column Name]:[Column Name]

ionam

Thanks for the help folks.

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.