Percentage within two rows

Erick Gutierrez

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

Mark Cronk

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

Bassam Khalil

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

https://www.youtube.com/watch?v=oWe8xwDHJ6Q

https://www.youtube.com/watch?v=OCljSnoLIsM&t=115s

https://www.youtube.com/watch?v=6c2W6U74in8&t=39s

Mark Cronk

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

Mark Cronk

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

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

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

https://www.youtube.com/watch?v=oWe8xwDHJ6Q

https://www.youtube.com/watch?v=OCljSnoLIsM&t=115s

https://www.youtube.com/watch?v=6c2W6U74in8&t=39s

Mark Cronk

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

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

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

Mark Cronk

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