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

Abbie G
Abbie G ✭✭
in Formulas and Functions

TODAY-date.

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)))

· Share on FacebookShare on Twitter

Answers

  • 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?

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!