I want to count dates in the colum "Solldatum" that are smaller than today.

I tried it with countif and it worked in Excel in German with the following formula:

=ZÄHLENWENN(A2:A13;"<"&HEUTE()) as Example.

What do I have to do in smarthsheet to get back the number of valid dates (in this example above the value "2")

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!