How to Track Someone's Past due Task

Hi, I have tried to write down a formula at the sheet summary that tracks the number of past due tasks assigned to a specific person on my sheet but it is giving a #UNPARSEABLE error below is how I have done it :

=COUNTIFS([Is Past Due?]:[Is Past Due?], "Yes", Status:Status, "In Progress", [Assigned To]:[Assigned To], FIND("Name of Assigned", @cell) > 0)

Below is a screenshot with the structure of my sheet


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!