Weekly Data Capture to other sheet
Options

Art A
ββ
I have a metrics sheet "Request Metrics Sustaining" that can tell me live how many tasks I have in each status that is in our process. On a separate sheet I want to get a snapshot of qty of tasks in each status weekly to have a running list. What's the best way to achieve this?
Answers
-
@Art A - Question, are you looking to have the most recent week's stats in your second sheet, or a total of all tasks in each status from all the weeks?
Or are you simply looking for a way to archive the data?
Michelle Choate
michelle.choate@outlook.com
Always happy to walk through any project you need help with! Book time with me here: https://calendly.com/michelle-choate