Calculating # of Projected Launches

Meghan Car
edited 06/21/24 in Formulas and Functions

Hi, I'm trying to calculate the number of rows with a projected launch within the next 15 days. I've tried:

=COUNTIFS({Implementation Data Tracker v2 Range 4}, <=TODAY(15))

=COUNTM({Implementation Data Tracker v2 Range 4}, <=TODAY(15))

I also want to note that I don't have any other specifics for this, such as project type, etc. All I need is the # of rows slated within the next 15 days so that I call have that pull into a dashboard.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!