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

brandon1

I have a project with many 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. 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

Please see my response here:

https://community.smartsheet.com/discussion/135007/how-to-set-up-columns-to-track-status-by-week-and-not-erase-when-moving-to-next-week