Date Formula

Chris Hallo
Chris Hallo โœญโœญโœญโœญ

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!

Capture.JPG


Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!