Countif + Date Range

Options

Hi

I am looking to put together a dashboard, I'm currently working on my aggregation sheet - I'm trying to count how many times a persons name appears in last 7 days in the selected reference column from my main smartsheet, I'm happy with how to specify the range and the person however I can't quite figure out the date range, so far I have:

=COUNTIFS({Reference count},Example name, date)

Thank you

Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    edited 11/18/20
    Options

    Hi @Becky Clayton,

    hope you are fine, please use the following formula:

    =COUNTIFS(List1:List12, Disname@row, Date1:Date12, >(TODAY() - 7))

    Best Regards

    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Options

    Hi @Becky Clayton,

    Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!