Countifs and past due formula help

Kiera3

I am trying to count the items that have a particular workstream, multiple status (blank, In progress) and Due date in the past. here is my formula:

=COUNTIFS([Workstream]:[Workstream], @row "QBR", [Status]:[Status], @row "In Progress", [Due Date]:[Due Date], @row <= TODAY())

the error I get is #unparseable. any ideas on help?

Thank you!

Debbie Sawyer

Try removing the @row elements...

=COUNTIFS([Workstream]:[Workstream], "QBR", [Status]:[Status], "In Progress", [Due Date]:[Due Date], <= TODAY())

Kind regards

Debbie

Chris Rea

I would recommend:

=COUNTIFS([Workstream]:[Workstream], Workstream@row = "QBR", [Status]:[Status], Status@row = "In Progress", [Due Date]:[Due Date], [Due Date]@row <= TODAY())

If memory serves me correctly you can't just use the "@row" because smartsheet doesn't know where to look.