Nested formulas



I have 3 formulas and I was wandering if I can combine them into 1:

=COUNTIF({Survey Date}, Label@row)

=COUNTIFS({Survey Date}, Label@row, {Survey Grade}, ">=8")

=Percentage@row / Count@row

Thanks much!



  • David Tutwiler
    David Tutwiler Overachievers Alumni

    I think that should be doable. But let me confirm I understand what you're trying to do. I think you're looking for a formula to CountIF:

    1) The survey Date is the same as the Label@Row


    2) The Survey Grade is >= 8

    And then once you have your count use is as the denominator of Percentage@row and that Count.

    If that is correct I think you would want your formula to look like the following:

    =Percentage@row / COUNTIFS({Survey Date}, Label@row, {Survey Grade}, ">=8")

  • Irina Iatco

    @David Tutwiler Thank you, David! You inspired me :) to create this formula and it worked: =COUNTIFS({Survey Date}, Label@row, {Survey Grade}, ">=8") / COUNTIF({Survey Date}, Label@row)

  • David Tutwiler
    David Tutwiler Overachievers Alumni

    Awesome! Glad to hear.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!