Rolling count for last 365 days

Options

Hi All,

I am very new to Smart Sheet and hope you can help. I would like to keep a count of entries into 7 columns (one per employee) for the last 365 days. The count will update each day to only reflect the last 365 days. The entries will simply be the number 1 in a column if that day should be counted for the employee. So basically for the screen shot attached (assuming the dat column continues to end of 2021) I would like to know how many 1's are in the 7 named columns for the last 365 days from the current day. I have looked at COUNTIF and TODAY-365 but to be honest am stuck. Any help appreciated.


Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!