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

Options

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?

 

Smartsheet.PNG

Comments

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

    Stephen,

     

    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.


    Craig

     

    Craig

     

This discussion has been closed.