COUNTIFS, Dates + 7, Checkbox Unchecked

Each day, I want to create a running total of unchecked checkboxes for today and the previous 7 days.

For this sheet, I need a Countifs, that will count from the date column and the previous 7 days of unchecked boxes for each column. It will be a total of unchecked boxes for all columns for today + the previous 7 days. (for the first row, it should just count the day).

I know this will be a COUNTIFS + formula, where I am really having problems is how to get it to count today + the last 7 days as of the date in the date column.

Thanks for your help!!

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!