Hi,
I am trying to create a tracking sheet that I can fill out daily accomplishments in the Log Sheet, then I have a sheet for each individual month that shows the sum of each activity for the month, but the data is transposed from the log sheet to the month sheet.. I am trying to figure out how to save my self some time so that I do not have to change the formula manually each time. If you look at the file, the output I am trying to capture is how I manually typed in October!B3:B33. Those are the same cells I would like to autofill with the transposed sums for each month. When I try to autofill currently it just repeats the pattern of whatever I have put in the cell.
docs.google.com
I am trying to create a tracking sheet that I can fill out daily accomplishments in the Log Sheet, then I have a sheet for each individual month that shows the sum of each activity for the month, but the data is transposed from the log sheet to the month sheet.. I am trying to figure out how to save my self some time so that I do not have to change the formula manually each time. If you look at the file, the output I am trying to capture is how I manually typed in October!B3:B33. Those are the same cells I would like to autofill with the transposed sums for each month. When I try to autofill currently it just repeats the pattern of whatever I have put in the cell.
Specialist Plan of Work and Annual Goals
Log Daily Activity Log,Reportable Metrics Date,Tasks Completed,Number of Contacts,Number of Field Visits,Number of Field Visit Acres,Number of Outreach Presentations Given,Number of Outreach Presentation Guests,Number of Boat Wash Events Conducted,Number of Boats Washed,Number of Boat Wash Impre...
