How to set up columns to track status by week and not erase when moving to next week?

brandon1

I have a project with tasks organized by rows. There is a column for status of each task. I've created columns for each week progressing into the future where I want to log the status at the end of each week in each column. My issue is that once we are in a new week, it leaves the previous column (week) blank.

How do I keep the data logged in each week?
Here is the formula I use in each week column. For reference, row 244 is the week start date, and row 245 is the week end date

=IF(AND($[Current Date]@row >= [1/5/25]$244, $[Current Date]@row <= [1/5/25]$245), $[Workflow / Status]@row, "")

Paul Newcome

You would need to set up a copy row automation that runs weekly and copies the rows over to a second sheet. You would then need to use an INDEX/COLLECT to bring over the appropriate week's status for each task from the static data on the second sheet.

brandon1

That's a great idea! I will try this. Thank you

Paul Newcome

Happy to help. 👍️