Count Cells with 'Today' date.

I am trying to add a Sheet summary Formula to count to my ticketing queue SmartSheet so I can count the number of tickets received in a day versus the number completed and determine a productivity percentage. I've tried several Count and Countifs formulas (I'm not very good at formulas yet). Any suggestions on what to use? Any help is appreciated.

I should mention also that I auto-update the Date Submitted (cell for which I am count occurrences of TODAY) with automation. I'm not sure if that has an impact or not.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!