Count Columns in data sheet to appear in calc sheet.

FGCC Smartsheet

I need help writing a Smartsheet formula that examines the "status" and "County if known" columns in a data spreadsheet. I want it to count the number of each type of status for each county. The Smartsheet containing the data is named "Test of File a complaint" the sheet where the calculation will appear is named "Complaints Calculation Sheet". I appreciate your assistance in the matter.

Jason Albrecht

Hi @FGCC Smartsheet

This may be a silly question, but the formula pasted above seems like it is designed for excel, not for smartsheet?

Can I assume that if you were to paste the Smartsheet formula here, it would look something like this?

=COUNTIFS({Test of File a complaint Country if known}, "Collier", {Test of File a complaint Status}, "Assigned")

This is assuming that the process followed included using the 'Reference Another Sheet' link when developing the formula...

... and then changed the range name when selecting the relevant columns from...

to

Thanks in advance for your clarification.

FGCC Smartsheet

I've tried different formulas. Why isn't this one working "=COUNTIFS('Test of File a complaint'![County if known]:`County if known`, "Collier", 'Test of File a complaint'!Status:Status, "Assigned")

Andrée Starå

Hi @FGCC Smartsheet

I hope you're well and safe!

Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

FGCC Smartsheet

@Andrée Starå Please let me know if you need more screen captures. The formula listed above returns "unparseable". This is an example of what I'm trying to build.

Jason Albrecht

Hi @FGCC Smartsheet

This may be a silly question, but the formula pasted above seems like it is designed for excel, not for smartsheet?

Can I assume that if you were to paste the Smartsheet formula here, it would look something like this?

=COUNTIFS({Test of File a complaint Country if known}, "Collier", {Test of File a complaint Status}, "Assigned")

This is assuming that the process followed included using the 'Reference Another Sheet' link when developing the formula...

... and then changed the range name when selecting the relevant columns from...

to

Thanks in advance for your clarification.

FGCC Smartsheet

Thank you for the replay. I'm working on the SmartSheets learning curve. It's like Excel but not exactly.

Jason Albrecht

Enjoy the journey. The community is here to help.

Feel free to reach out with more questions / clarifications as or when needed.

Otherwise, let us know how you go with this one, as others with similar challenges will appreciate your resolution.