Easy way to express Monthly Data

Hi all,

I have started a project to use Smartsheet to track Right First Time across several departments. As part of this I want to track the data on a monthly basis.

The form uses a 'Created date' field to input the date when the entry was submitted.

Is there a way of expressing the date, so I can use it as a COUNTIFS formula?

=COUNTIFS({Site}, "Hay-on-Wye", {Service Area}, "Specifications/Artworks", {Right First Time}, "Yes")

Or have I over complicated it, is there an easy way to show monthly data, without having to use COUNTIFs, "August" for example?



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!