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:

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

brandon1

Jan 14, 2025

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, "")

---

View Post

Paul Newcome

Please see my response here:

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

brandon1

Jan 14, 2025

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, "")

---

View Post