Jan 25, 2021

Sorting Throughout Multiple Sheets Issue

I have one spreadsheet that contains multiple sheets within it.

The first sheet I have a list of all the salespeople along with their sales for each month and a total of YTD sales in a column. 

Then I have monthly sheets with a summary of the MTD Sales. 

Then I have weekly sheets with each individual sale by person and date. 

Each person has their own row. 

I referenced the first sheet in the other sheets to keep the names updated as we hire. But when I add a new person on the first sheet and sort the column to put it in alphabetical order, it sorts in the other sheets but then the rest of the row in those sheets do not sort with it. It does in the first sheet, but not the rest. I need each writer to stay with their row of information in each sheet no matter how I sort them in the first sheet. Is this possible or is there a better way to do this?

I also would like to rank each salesperson based on their total sales. Not quite sure how to do that and keep them from moving with the rest of the information. 

I have attached the link to the sheet for reference. 

Locked
Informational notification.
This question is locked and replying has been disabled.
Community content may not be verified or up-to-date. Learn more.
Last edited Jan 26, 2021
All Replies (7)
Jan 26, 2021
Hi Brooke,
 
Can you please change the permissions to "Anyone with link can edit?" Currently it's set such that we can only view the sheet.
Jan 26, 2021
I adjusted to edit link. Thank you!!
Jan 26, 2021
Thank you.

There are a few ways this can be accomplished, but the right one depends on how you use this. Do you need the other sheets to sort, or do you only need to actually view the data on the year summary page?
Jan 26, 2021
I need the other sheets to sort so that the right info stays with the right salesperson. If I try to add a name to yearly and sort in A-Z order on the other sheets it will sort but then their name is in the wrong row.
Jan 26, 2021
Ok. With standard Sheets functions that means you probably need to design this more like a database. ALL the data will either be KEPT in 1 sheet and filtered to the other sheets as view-only portals or kept in the lowest sheets (week) and filtered up as view-only.
The way you're presenting just isn't what spreadsheets are designed to do.
Jan 26, 2021
Okay. Thank you!
Jan 27, 2021
Brooke,

You may find it helpful to read through this post from Lance, another of the top experts here, along with Spencer.  His post adds some more to Spencer's description of the issue.  And he also points back to a previous lengthy discussion on the design aspects of having dynamic data and "notes" that get added to records.

After reading through that, if you are still looking for help, please post back here or enter a new revised question.

Cheers,
Gill
false
3021234706813140021
true
Search Help Center
true
true
true
true
true
35
Search
Clear search
Close search
Main menu
false
false