Date formula

Nkeiruka. Aguocha

Hello Community,

I'm sort of new to Smartsheet, especially formulas😆 I'm trying to pull up a formula that tell me how many documents were created from that month, from the column. When choosing the entire column (including blank cells), I can't seem to close this out correctly. Can someone please assist? I would greatly appreciate it☺️. Below is what I was trying to use. Thanks!!

I was trying to pull how many documents were created for the month of August(9) and so on and so on...

=MONTH({DCR Log and Approvals Range 1},IFERROR(MONTH,("9")))

Kelly Moore

Hey @Nkeiruka. Aguocha

To verify, this type of range reference {DCR Log and Approvals Range 1} indicates that the data from one sheet is being pulled into another (ie, the data and formula are not on the same sheet).

=COUNTIFS({DCR Log and Approvals Range 1}, IFERROR(MONTH(@cell), 0)=9)

The above formula counts IF the Month in the cell is equal to 9 (9 is Month = September). If the Month function produces an error, count that particular cell as zero. Note that the numbers within a formula are not enclosed in quotes.

Does this work for you?

Kelly

Kelly Moore

Hey @Nkeiruka. Aguocha

To verify, this type of range reference {DCR Log and Approvals Range 1} indicates that the data from one sheet is being pulled into another (ie, the data and formula are not on the same sheet).

=COUNTIFS({DCR Log and Approvals Range 1}, IFERROR(MONTH(@cell), 0)=9)

The above formula counts IF the Month in the cell is equal to 9 (9 is Month = September). If the Month function produces an error, count that particular cell as zero. Note that the numbers within a formula are not enclosed in quotes.

Does this work for you?

Kelly

Nkeiruka. Aguocha

Hi Kelly,

Thank you so much for answering, and yes it worked😀!!!! Thank you!!