Kenny Tunn
Kenny Tunn ✭✭
edited 07/13/21 in Formulas and Functions

Hi All,

Newbie posting. Been using smartsheet for my projects and keen to delve more into the reporting side for Board information. I have a Smartsheet that I use to record installs of certain types of products, we have three different types. I have used a formula to count the number of each type of product with an example below:

=COUNTIF(Product:Product, ="Big Yin")

The above is working fine. Recent price changes have resulted in me being asked to report on each product installed from a certain date, 27/06/21, below is the formula I have at the moment that does not work:

=COUNTIFS(Product:Product, ="Big Yin", AND(>=DATE(2021, 6, 26)))

Getting IVALID OPERATION and no idea why, probably something obvious. Any help greatly appreciated.


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!