I have a sheet where I calculate the average of the daily value for the past 30 days with a rolling average. I'd like to be able to pull the daily values and store them in another sheet. I want to store the static values from that day. When I add in the next days' data the average changes but I don't want the stored value to change.

The data source is stored in sheet "Workbook" with a list of names and that individuals average stored in A19:A30 and B19:B30 respectively. The output should be the name with their average from a specific day. Ideally, I'd like the output to be sorted in ascending order by average.

I hope this makes sense.

  • 1
    StackExchange is not suited to working as a coding workshop, and is also naturally not a free programming service. Have you made a start at it? [See: How to Ask.] None of your stated needs are rare, and the task is clear, so doing a bit of research and getting the script working should be relatively straightforward. Let us know what problems you hit. – Joel Reid Jun 13 at 11:38
  • Thanks for the response. I appreciate your perspective and will review the how to ask section you've listed. This is the first time I've ever coded anything in Google sheet. My attempt at searching led me to StackExchange where some people had responded with previous scripts prompting me to ask. My complete unfamiliarity is likely the problem here. I hoped to find a relevant script that could be adjusted to my needs but wasn't able to find anything likely because I don't even know what commands are required. I'd appreciate suggestions on relevant commands, resources, or similar scripts. – Lance Salmikivi Jun 13 at 15:06
  • Work so far <br/> code function PullDay1() { var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Workbook"); var CurrentPick = ss.getRange("A19:B30"); var outputCell = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("WEEK ONE DAYS 1-5").getRange("P7:Q18"); outputCell.setValue(CurrentPick.getValue()); }code <br/> Unfortunately this returns the same value (a persons name) in all cells in range P7:Q12. – Lance Salmikivi Jun 13 at 17:27
  • Please edit your questions to show your progress. – Rubén Jun 18 at 13:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.