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