# Formula: looking for BOTH "In Progress" & "Not Started" Tasks

Employee
This discussion was created from comments split from: Count If Current Week.

• Hi Paul,

I'm looking for results on the below condition :

•New Tasks that are upcoming only for next week (In Progress & Not Started)

When I use the below formula, I get "In Progress" Tasks as expected.

=COUNTIFS([End Date]:[End Date], <=TODAY(7), [End Date]:[End Date], >TODAY(),[Status:Status],"In Progress")

***But I'm looking for BOTH "In Progress" & "Not Started" Tasks. Using the below formula I get an error #PARSEABLE...

=COUNTIFS([End Date]:[End Date], <=TODAY(7), [End Date]:[End Date], >TODAY(),[Status:Status],"In Progress",AND[Status:Status],"Not Started")

Thank you

• ✭✭✭✭✭✭

@Sunny Kaul Try this...

=COUNTIFS([End Date]:[End Date], @cell <=TODAY(7), [End Date]:[End Date], @cell >TODAY(), [Status:Status], OR(@cell = "In Progress", @cell = "Not Started"))

• Sorry Paul, but =Could you specify what @cell represents?

COUNTIFS([End Date]:[End Date], @cell <=TODAY(7), [End Date]:[End Date], @cell >TODAY(), [Status:Status], OR(@cell = "In Progress", @cell = "Not Started"))

• ✭✭✭✭✭✭

"@cell" is essentially telling the formula to evaluate the previously established range on a cell by cell basis.

=COUNTIFS([End Date]:[End Date], @cell <=TODAY(7), [End Date]:[End Date], @cell >TODAY(), Status:Status, OR(@cell = "In Progress", @cell = "Not Started"))

The bold portion is basically saying to count the rows in the Status column where the cell equals "In Progress" or the cell equals "Not Started".

• Thank you, Paul! It's giving me the expected results! :)

• ✭✭✭✭✭✭

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!