nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

Formula to count values in a column

BESP10

Good evening

VERY NEW to smartsheet.

I am creating a metrics sheet for data we want to capture on another sheet.

How do I get the QTY of "beam" counts in this column?

Thank you

Find more posts tagged with

Sheets

Reports

Support

Cell linking

Comments

Andrée Starå

Hi,

I'd recommend counting and collect the metrics needed on the sheet first and then use cell linking to the metric sheet if needed.

Try this.

=COUNTIF([Piece Type]:[Piece Type]; "Beam")

The same version but with the below changes for your and others convenience.

=COUNTIF([Piece Type]:[Piece Type], "Beam")

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Let me know if you still want/need to collect it directly on the metric sheet, and if you need information on how to set up cross-sheet linking.

Would that work?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

BESP10

That worked

So simple...

Never to old to learn

Thank you !

Andrée Starå

Great!

Happy to help!

Best,

Andrée

BESP10

Good evening,

Sorry to bother, but I thought I got this to work but I am getting an "unparseable" error.....

I have the formula as =COUNTIF([Piece Type]23:[Piece Type]352),"Other") but it is not counting

What could I be doing wrong here?

Thanks

Andrée Starå

Hi,

No worries! I'm always happy to help!

You have one parenthesis too much. The one after 352 shouldn't be there.

=COUNTIF([Piece Type]23:[Piece Type]352),"Other")

Did it work?

Best,

Andrée

BESP10

YES!!!!!

Thank you!

Andrée Starå

Great!

I'm always happy to help!

Best,

Andrée

BESP10

Is it possible to use the "children" function here? so that as more rows get added to the bottom we do not need to update formula everytime?

Thank you

Andrée Starå

Yes, try this.

=COUNTIF(CHILDREN([Piece Type]22), "Other")

Did it work?

Best,

Andrée

BESP10

Hmmm, this formula gives me the proper count of 5 -

=COUNTIF([Fab Type]27:[Fab Type]372, "Bolt/Weld")

But when I change it to

=COUNTIF(CHILDREN([Fab Type]27), "Bolt/Weld")

It comes up as 0 ?

Andrée Starå

It's probably because you're referencing a child row and not the parent row.

If it's the same row as on your picture, then try changing it to row 22.

Did it work?

Best,

Andrée

BESP10

BINGO!

Thanks

Andrée Starå

to help!

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

"Fields marked with an asterisk (*) are required." line on every form.
Hi, "Fields marked with an asterisk (*) are required." is the very first line in the body of every form I create. I don't remember seeing it before (unless you missed filling out a required field; then you would see the message). Is there a way to turn it off or change it? None of my forms are in English so the message is…
Best Way to Create a Stacked Bar Chart from multiple columns
I have a sheet that I pull into a report. The report I then want to use to make a stacked bar chart and put into a dashboard if I can. The columns I am trying to make into a stacked chart are: Lead, project and phase. The issue is that there are several leads and I need the stacked bar chart to show in different colors for…
Dynamic View Issue - Group Sharing
I have a dynamic view setup for a dashboard that has NO restrictions And on the Sharing tab, I have a Group that I created as the additional share access to the view But the individuals in the Group still cannot see the data from the dashboard. Am I missing something? Because when I share the view to them individually…