Trying to count today only


I have an employee sign-in sheet where I want to show todays stats or metrics.

This is how I count

=COUNTIF({Bergmeyer Employee Sign-In Range 2}, ="WFH")

I wanted to do something like

=COUNTIF({Bergmeyer Employee Sign-In Range 2}, ="WFH", Today())

but it doesn't work. I don''t know how I tell it the date is in a different range or column?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!