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?

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]

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