Hi all - I am creating a calculation sheet that reference a ticket intake smart

sheet. I want to use this calculation sheet to count based on the country that submitted it and what the status of the ticket is.

Complete = Complete

Open = Not Started, In Progress, Blocked

Reference intake sheet:

I keep getting #UNPARSEABLE when I use the range of the country in the intake form and use the cell in the calculation sheet, and range of status column and range of cells in calculation sheet.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!