Countifs

RTemples

We are trying to build our dashboard and I want a total number of “Deliverables” across five sheets but looking at a column counting where Deliverables is listed and I can't seem to get the formula right and I can't seem to pull in a specific field from a report.

See test formula (across two sheets) and I keep getting Contact Expected.. Is Countfs the right formula? 

Kelly Moore

Hey @RTemples

What column type is the column where you are inserting the formula? Are you trying to put this in a Contact column?

Kelly

Scott Orsey

Hi @RTemples , The #CONTACT EXPECTED error is likely because the column where you have put your formula is a Contact List. Your formula should be expected to return a number (a count) which is not allowed in a Contact List column.

As for your COUNTIFS() formula... it looks fine based on the information you supplied. Just make sure that the word "Deliverables" appears in the cross-sheet columns {TSA Range 2} and {Cyber Security Range 1}. Otherwise you will return zero.

Hope this helps. Good luck and be well!

che.rabajante

Hello @RTemples

Use COUNTIF function instead of COUNTIFS.

Hope this helps!

che

RTemples

https://community.smartsheet.com/discussion/comment/427343#Comment_427343

Yeah that is the problem.. I was just trying to put the formula at the bottom of a sheet but the column is a contact list which I guess doesnt allow a count.

RTemples

https://community.smartsheet.com/discussion/comment/427344#Comment_427344

Yeah that is the problem.. I was just trying to put the formula at the bottom of a sheet but the column is a contact list which I guess doesnt allow a count.

Kelly Moore

@RTemples

Consider using a sheet summary field (Located on right panel alongside sheet). Add a Text/Number field and insert your formula there. You can access Summary fields from dashboards and/or reports

Kelly