Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Counting the number of Red Symbols in Parent Rows Only

Brent L

Brent L ✭

03/31/17 edited 12/09/19 in Archived 2017 Posts

I would like to count the number of REDs for Parent cells only (not children). Any help would be much appreciated.

Count Reds.jpg

Tags:

IT & Operations

0 ·

Comments

Brent L ✭

03/31/17

To clarify, the blue rows are children of light tan rows, so technically not primary Parent.

0 · Share on Facebook Share on Twitter
Gen Boyes ✭

02/08/18

=countif(children(Column51), "Red")

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Is there a way to have automation to run monthly?
Hi Everyone, I can see automation can be sent hourly, daily and weekly. Is there a way to have a monthly option? Thanks Tracy
"Boolean Expected" Error
Hello All, I spent a few hours building an equation (I am not an expert) within a sheet that reads another main sheet. =IFERROR(INDEX(COLLECT({GenFertCalc}, {Client Name}, [Client Name]@row, {Tones}, "Granular Fertilizer (Tone)"), 1), 0) The error message "Boolean Expected" occurs in the correct cells, but instead of…
how to get a checkbox
I am so new to this, and I am trying to add a check box to a column and not having any luck. I have named the column, and I select checkbox, but it does not show.