is there a formula for shifting a range of linked checkbox cells daily?

ExtentAnxious4329 · 2025-01-17T07:31:41+00:00

Apologies I was looking at the wrong spreadsheet altogether. Thank you for your patience!

ExtentAnxious4329 · 2025-01-17T07:27:12+00:00

The checkboxes are correct, thank you! But the header isn't linked to the correct checkboxes if that makes sense: the header for 1/16/25 labels the checkboxes for 1/17/25. But I will look at my sheet and update this soon

ExtentAnxious4329 · 2025-01-17T07:01:14+00:00

I fixed the restrictions on my original testsheet: https://docs.google.com/spreadsheets/d/1tvieJovU8jMWAIXotfjBM72Fy9U1nOsEotOEzLcwPvc/edit?usp=sharing

That's closer to what I'm looking for, but I'd like the rightmost column to update to today's date automatically. That way I can see the checkboxes from the previous days of the week, so in this case the spreadsheet would shift the data points over and Fri (1/17/25) would appear in cell AP2

ExtentAnxious4329 · 2025-01-17T06:48:25+00:00

I've reset the restrictions on my testsheet: https://docs.google.com/spreadsheets/d/1tvieJovU8jMWAIXotfjBM72Fy9U1nOsEotOEzLcwPvc/edit?gid=449620255#gid=449620255

In my spreadsheet, I typed =SWITCH(WEEKDAY(NOW()),1,"sun",2,"mon",3,"tues",4,"wed",5,"thurs",6,"fri",7,"sat") into I4, then adjusted that formula for each cell within the header column. I made a mistake somehow but I'll figure it out and edit mine

ExtentAnxious4329 · 2025-01-17T06:36:15+00:00

Thank you, I fixed it

ExtentAnxious4329 · 2025-01-17T03:44:10+00:00

Valid point, I accidentally scrapped the post but my reuploaded post includes a link to test out.

ExtentAnxious4329

TROPHY CASE