COUNTIFs for Dates

KMan1190
KMan1190 ✭✭✭✭
edited 12/09/19 in Formulas and Functions

I'd like to create a formula which only counts the Rows in which a date in a particular column is in the last 30 days (among other criteria)



=COUNTIFS({Referral Source}, "Elm", {Database Status}, "Green", {Database Date of Referral}, <TODAY(-30))

The section in Italics is the area I am trying to sort out.

Thanks in advance for any help.

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!