Weekly Data Capture to other sheet

Art A
Art A
edited 02/13/25 in Smartsheet Basics

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

  • Michelle Choate 2
    Michelle Choate 2 Community Champion

    @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