CountIF text string criteria by day, week, month

Hi Everyone,

Wanted to provide a bit of a background before posing the question, I had set up an intake form which collects information of events. To analyze the raw data, I set up another worksheet to where I could keep all the formulas. In the second worksheet, I am trying to count the number of times a specific event is occurring by day/week/month and the second criteria placed would be the name of the event for which I already have a column set up being referenced. I have provided the formula below that I am using, what am I doing wrong, as I would really like to learn and enhance my knowledge for formulas within smartsheets.

=IF({Incident Log with Form Range 2} = TODAY(), COUNTIF({Incident Log with Form Range 1}, [Incident Type]@row), " ")

PS. this formula was only for calculating today, but ideally I would like one for Day, Week & Month. I have also attached shots of both worksheets, any assistance would be much appreciated.

Thanks in advance!

Best Answer


  • Hi Genevieve,

    Problem solved! thanks for getting back to me.

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Sarbuland Bangash

    No problem at all! I'm glad I could help.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!