Calculating # of Projected Launches

Meghan Car

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.

jmyzk_cloudsmart_jp

Hi @Meghan Car

I tested your formula with a demo sheet and found no problem.

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

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

(Note: since you have one range and criteria pair, you can also use COUNTIF.)

https://app.smartsheet.com/b/publish?EQBCT=e91c39e7185d41d0bd6b3c39d91d0135

https://app.smartsheet.com/b/publish?EQBCT=3cc3064f1d614b2fa62da9e9b5857fd1

Check your range

One possible problem is your reference.