Countifs and past due formula help

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!

Answers

  • Debbie Sawyer
    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
    Chris Rea ✭✭
    edited 07/01/20

    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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!