Date Formula


Good morning! I need help with a date formula (highlighted). It's counting but not the total where the start date is in the next 7 days. You can see the sheet summary fields as I want to use the "7 days out" as a metric on a dashboard. If I replace the range1 to a unique column, the formula returns zero...I'm confused. Help, please!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!