Countifs not working properly

JHorrocks

Hi Everyone,

I'm looking to pull any trainings that were "Direct" from the Past 30 Days. Anytime I enter the formula it says #Unparseable. I'm not sure where I'm going wrong.

=COUNTIFS({Training Type Column}, "Direct", {Date Entered Column}, ">=" & TODAY() - 30)

jmyzk_cloudsmart_jp

Hi @JHorrocks

Please try one of the following;

=COUNTIFS({Training Type Column}, "Direct", {Date Entered Column}, >=(TODAY() - 30))

=COUNTIFS({Training Type Column}, "Direct", {Date Entered Column}, >=TODAY(-30))

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

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