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

IF level@row = X, Display short version of dashboard link, else calculation
Hello Community, I have a series of columns that are summarising the output of complex projects. I would like to be able to have a "Link to Dashboard" at the top of a column that is a column formula. The link would provide the end user with instant access to more detail if required. Ideally if anyone has a solution, the…
Using IF with Find
Hi, I'm trying to simplify a cell's contents, to allow better cross referencing and help eliminate issues with typos. I create cells with a serial number, someone requests that serial number though a form. Since the serial number can have a lot of variations requests through the form can have typos leading to the cross…
Nested(?) If statements
Not sure if nested is the right term. I want the formula to show - If any of these columns (IT, SUS, HSE etc) have "Not Achieved" in them then look for the largest/ latest date from the columns IT comp. SUS Comp. HSE Comp. and display that date. Otherwise "Badges complete". The result column is a date column so not sure if…