Dashboard formula counting rows within date range

First post, Longtime SSheet user but new to formulas and stuck on this last one for a dashboard. 

I am trying to count rows where the due date is within a range, the form created date is within 14 days of the due date and the status is not "complete." I have tried a wide variety of solutions. 

=COUNTIFS({FAMS Marketing Calendar | 2019 Range 6}, @cell >= TODAY(-15), {FAMS Marketing Calendar | 2019 Range 6}, @cell < TODAY(15), {FAMS Marketing Calendar | 2019 Range 2}, @cell <> "Completed", {FAMS Marketing Calendar | 2019 Range 4}, <{FAMS Marketing Calendar | 2019 Range 1})

Rang 4 is the created date and I have tried removing the time from this also.

I think I am close and any help would be appreciated.

 

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!