Another COUNTIF question...


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


  • LukeFortney

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

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


    I'm always happy to help!


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

    W: | | 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!