Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Countifs not working properly

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)

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions