I am trying to create a COUNTIF formula that counts the number of rows where the date is 100 >


It doesn't seem to count all the rows where the date has more than 100 days. This is the current formula I have right now

=COUNTIFS({role}, "abbie", {PRJT}, $[Project Type]@row, {date}, @cell > (TODAY(100)))


  • David Tutwiler
    David Tutwiler Overachievers Alumni

    I'm not totally sure what it is you're trying to do, but it might be helpful to describe what your current formula is doing. Once you get to the {date} group, you are checking that the date in the row is greater than TODAY + 100 days. So you're essentially checking to see if the date in the cell is more than 100 days away.

    Is that what you were trying to do?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!