Percentage within two rows

image.png

Can someone help me with a formula to determine what % is "Reps in NV" of the "Total Reps"?

Best Answers

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer βœ“

    Hi @Erick Gutierrez ,

    In the % Column enter this formula:

    =count@row/count$1. It will calculate the percent of total for each.

    There are lots of good training materials and videos in the learning center ot available on YouTube. You'll have the hang of this in no time.

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Answer βœ“

    Hi @Erick Gutierrez

    Adding to the excellent answer of @Mark Cronk please find in the following some videos to help you to understand formulas in smartsheet




    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"

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer βœ“

    Good morning @Erick Gutierrez ,

    Again, happy to help. The formulas you're looking for are below but I don't understand your table, more below formulas.

    % of 25 Taking calls of 40 Total Reps: in the % of total row below 25, insert: =MA3/Count1

    % of 21 Taking calls of 40 Total reps: in the % of total row below 21, insert: =COMM3/Count1

    As for your table, you asked to calculate a percent of the total taking calls. However, Competent + Learning + Taking Calls doesn't equal 40 in any of the columns. Granted, I don't know what MA, COMM, ASO2 or WP represent so this may make sense to you. Are you getting the right counts in each column and row of that table?

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Answers

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer βœ“

    Hi @Erick Gutierrez ,

    In the % Column enter this formula:

    =count@row/count$1. It will calculate the percent of total for each.

    There are lots of good training materials and videos in the learning center ot available on YouTube. You'll have the hang of this in no time.

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

  • Erick Gutierrez
    Erick Gutierrez ✭✭

    Thank you very much! That helped, and makes sense. Would you be able to help me with the formulas for the % of 25 Taking calls of 40 Total Reps, 21 Taking calls of 40 Total reps, for the life of me, I can't figure it out! also do you have the link for the videos that you mentioned? I hope you can help! Thanks again!

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Answer βœ“

    Hi @Erick Gutierrez

    Adding to the excellent answer of @Mark Cronk please find in the following some videos to help you to understand formulas in smartsheet




    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"

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer βœ“

    Good morning @Erick Gutierrez ,

    Again, happy to help. The formulas you're looking for are below but I don't understand your table, more below formulas.

    % of 25 Taking calls of 40 Total Reps: in the % of total row below 25, insert: =MA3/Count1

    % of 21 Taking calls of 40 Total reps: in the % of total row below 21, insert: =COMM3/Count1

    As for your table, you asked to calculate a percent of the total taking calls. However, Competent + Learning + Taking Calls doesn't equal 40 in any of the columns. Granted, I don't know what MA, COMM, ASO2 or WP represent so this may make sense to you. Are you getting the right counts in each column and row of that table?

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

  • Erick Gutierrez
    Erick Gutierrez ✭✭

    Thanks again Mark! Once again I learned something new. Yeah I totally see what you're saying about the Competent +Learning +Taking Calls not adding up, I'm actually adding Competent + Learning= Taking calls. This community is so helpful, I can't wait to continue to learn on here, now if I could just come up with an outlier formula.

  • Erick Gutierrez
    Erick Gutierrez ✭✭

    You've been amazing, Mark! I spent most of the day yesterday trying to figure this out. This would be the last piece of the puzzle:

    image.png


    Could you help with one last formula to determine the %'s of Column CA Tier for CA, CA1,CA2, and CA3

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    edited 12/08/20

    Sure Erick,

    The formula in the % row would be:

    CA =MA7/sum($MA$7:$WP$7)

    COMM =COMM7/sum($MA$7:$WP$7)

    ASO =ASO7/sum($MA$7:$WP$7)

    WP =WP7/sum($MA$7:$WP$7)

    Copy and paste that into the other 3 columns. Then change the 1st MA to COMM, ASO, and WP. The "$"s in the formula keep that range from changing when you copy it across - a static reference.

    Based on your image I'm assuming that the counts are in Row 7. If they aren't you'll need to change the number in the formula to the right row.

    Work?

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!