Cell Formula For Traffic Light Symbols

Hello, see attached screenshot. in the yellow cell (top right) I am wanting to have a SUM of the below 'Days To Complete' cells, but only those that have the Green traffic lights.

As you can see this is a team members project list, so we are trying to estimate the work ahead for this team member.

Can someone please help with a formula to do this?


Tags:

Best Answer

  • Genevieve P.
    Genevieve P. Employee
    Answer ✓

    Hi @Trent Simpkin

    The CHILDREN function will want you to reference the Parent Row Cell, versus selecting a range. It will create the range for you!

    Try copying/pasting exactly this:

    =SUMIF(CHILDREN(Status@row), "Green", CHILDREN())


    In the second Children reference, you don't need to add any column names or rows at all. If you leave it as () then it will know to look at the children of this column. Make sense?

    See: CHILDREN Function

    Cheers!

    Genevieve

    Need more help? 👀 | Help and Learning Center

    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!