Percentage within two rows
Can someone help me with a formula to determine what % is "Reps in NV" of the "Total Reps"?
Best Answers
-
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.
-
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
☑️ 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"
-
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
-
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.
-
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!
-
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
☑️ 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"
-
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.
-
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.
-
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:
Could you help with one last formula to determine the %'s of Column CA Tier for CA, CA1,CA2, and CA3
-
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
Categories
Check out the Formula Handbook template!