For a summary report

Ashley McAdoo
Ashley McAdoo ✭✭✭✭✭
edited 11/01/22 in Formulas and Functions

Hello, I am trying to count how many things have been completed in the past 7 days. This is my formula =COUNT([Completion Date]1:[Completion Date]50<=TODAY(-7)). The answer should be 2, but it is calculating only 1, Help and thoughts?



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!