Another COUNTIF question...

Options

Honestly, I don't really know how to do any of the cold call metrics on my screenshot below.

Last Month: I want to count the number of rows where the "Last Touch" date is in the previous month. Not sure if this is even possible without having to update the formula each month.

This Month: Same as above, only current month.

Last Touches>6 Monthes Old: Count the rows that have the "Last Touch Date" more than 6 months in the past. (or 180 days is fine.)

Next Touches Overdue: Count the rows that have the "Next Touch Date" in the past.




Best Answer

Answers

  • LukeFortney
    Options

    Wow, amazing! I didn't even know if those formulas were possible. Thanks!!!

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Options

    @LukeFortney

    I'm always happy to help!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!