Results 1 to 2 of 2

Thread: Weekly Team and Individual Leaderboard
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jun 2015
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Weekly Team and Individual Leaderboard

    Hello,

    I'm lost (per usual) and have searched long enough that I'm starting to go insane so my next step is to post my questions here.

    Our sales team is needing/wanting a leader board to not only monitor and display the individual sales but also the team (groups of 4 people) sales.

    So every week would be a challenge and at the end of the week a leader board would display all sales people and then one with all 11 team sales.

    My first question...If Joe, Bill, and Frank (not Sally) are on Team 1 Can I have a sheet like this:

    Name Sales Points Team Total
    Joe 1 1 Team 1 6
    Sally 2 2
    Bill 3 3
    Frank 2 2

    Also, is there anyway to automatically sort the sheet based on rank? I can get the rank of all sales people but week by week it would be nice to not have to sort (but that's not the hardest thing in the world).

    Is there a way to send an entire row to the bottom of a range based on a cell? For instance, if we have sales people who only do online sales they would get bumped below the others.

    Example:

    Name Sales Points Online?
    Joe 1 1 N
    Sally 2 2 N
    Bill 3 3 N
    Frank 2 2 Y

    And what's the best way to get the sum and display the overall Team leader board as the weeks go by? I believe each week will be on its own sheet.

    I appreciate any and all advice on this one. The most difficult part is probably getting what I want (and what I want to ask) from my brain to right here...so hopefully I made a little sense.

    Thanks in advanced!

    - Dan
    Last edited by danjris; Oct 15th, 2019 at 02:51 PM.

  2. #2
    New Member
    Join Date
    Jun 2015
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Weekly Team and Individual Leaderboard

    Maybe these tables will help the vision a little
    Last edited by danjris; Oct 15th, 2019 at 02:59 PM.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •