Date formula

Options

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

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓
    Options

    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

Answers

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓
    Options

    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
    Options

    Hi Kelly,

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!