Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Formula help!!


Please view the screenshot I have provided below.


I am attempting to create a formula here that takes the whole assigned to row and the end date row. I want it to show the number of times it shows a certain name, in this case Dean, and if that task is one week past the current date. I would also like two weeks and three weeks or more. I  imagine the formula to look something like this below but I cannot quite get it right.


Formula: =COUNTIFS([Assigned To]:[Assigned To], "Dean Anhorn", [End Date]:[End Date], @cell >= (TODAY() - 7))


any insight?




  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭



    Your formula is looking for a matched between [End Date] from 7 days ago into the future, not 7 days ago and earlier.

    Try <= instead of >=


    Also, in this case, you do not need the @cell reference.


    Hope this helps.





This discussion has been closed.