Easy way to express Monthly Data

Jack Parry

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?

Thanks,

Jack

Paul Newcome

Try this:

=COUNTIFS({Site}, "Hay-on-Wye", {Service Area}, "Specifications/Artworks", {Right First Time}, "Yes", {Date Of Review}, AND(MONTH(@cell) = 8, YEAR(@cell) = 2022))

Paul Newcome

Try this:

=COUNTIFS({Site}, "Hay-on-Wye", {Service Area}, "Specifications/Artworks", {Right First Time}, "Yes", {Date Of Review}, AND(MONTH(@cell) = 8, YEAR(@cell) = 2022))

Jack Parry

@Paul Newcome Worked! Thank you :)

Paul Newcome

Happy to help. 👍️