Sub-tasks /formulas

Joanna Chu
Joanna Chu ✭✭
in Formulas and Functions

There are many subtasks with RYG balls. I need a formulas could based on different numbers of sub-tasks and display the Health result on their parent row(as red part).Please help, thank you...

Q&A.jpg


· Share on FacebookShare on Twitter

Best Answer

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Answer ✓

    Hi @Joanna Chu

    Hope you are fine, did you mean if you have one subtask with the red ball you want to show in the parent a red ball.

    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

    · Share on FacebookShare on Twitter

Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Answer ✓

    Hi @Joanna Chu

    Hope you are fine, did you mean if you have one subtask with the red ball you want to show in the parent a red ball.

    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!