Count Children in adjacent column

SummerEdwards
SummerEdwards ✭✭
edited 12/09/19 in Formulas and Functions

How do you write a formula to count certain values of an adjacent column from where you want to the count value displayed.  In my sheet I need to count open positions and filled positions based on the status.  My sheet is very large so I have to replicate this many times with varying row #s so looking for a quick way to tell the sheet to count the values of children rows in the status column.  

Thanks in advance! 

SS Staff Patterns Columns.JPG

Comments

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi Summer,

    Not sure I follow! Do you want to COUNT or SUM the children of specific rows? Do you want to show the calculated value on the same row as the parent?

    Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

    Have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!