Date formula
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")))
Best Answer

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
Answers

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

Hi Kelly,
Thank you so much for answering, and yes it worked😀!!!! Thank you!!
Help Article Resources
Categories
Check out the Formula Handbook template!