Formula help counting back 30 days

dave.mcpherson56751 ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

Hi I am trying to create a formula that count all entries by a certain person within the last 30 days. This is a cross sheet formula and seems to work well.

Now comes the however!

I have the below formula which does the calculation, however if a date is in the future it still counts it.

=COUNTIFS({Monmouthshire Housing incident reporting Range 1}, >TODAY(-30), {Monmouthshire Housing incident reporting Range 2}, "Sue Kidd")

Is there any advice on how to tweak this formula so it only counts 30 days in the past and discards future dates.

Thank you as always for any help or guidance.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!