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.

Count Number of Children Cells that are not blank.

Richard Lucas

Richard Lucas ✭✭✭

06/21/17 edited 12/09/19 in Archived 2017 Posts

I'm having difficulty with this one.

I have a parent row of "Rental Lead"

I would like to count the number of child cells in column "Training Course" under the parent "Rental Lead"

Richard E. Lucas

http://www.linkedin.com/in/richardelucas

Tags:

0 ·

Comments

Richard Lucas ✭✭✭

06/21/17

Fixed my issue.

It's a Date formatted column so I had to use.

="(" + COUNT(CHILDREN()) + ")"

Richard E. Lucas
http://www.linkedin.com/in/richardelucas
0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

INDEX/COLLECT with both MATCH and CONTAINS criteria
I am looking for help with a cross-sheet INDEX/COLLECT formula. I need to MATCH in one criteria and CONTAINS in another criteria. I can get them working separately but I don't know how to combine into a working formula. Source Sheet: Destination Sheet: In the Attending School column in Destination Sheet, I'd like to…
Parent Color Symbol, Based on "Average" of Child Symbols
Okay, here I am again! On the Project I am working on, the Stakeholder wants parent rows for no reason other than to be able to expand and collapse the data. I nicely suggested that since the data would only be for 1 year (broken down in quarters and about 5 users listed each quarter), that since the data was not excessive…
Can someone please help me with a COUNTIFS formula?
I can't seem to get this formula to calculate any results other than 0 COUNTIFS({11.08.2024- Labor Allocations for Smartshe ES}, [Expense Specialist]@row, {11.08.2024- Labor Allocations for Smartshe FU}, OR(@cell = "410101", @cell = "41201", @cell = "410202", @cell = "410203". This is only a part of a larger formula.