Welcome!

Need help with COUNTIF and #UNPARSEABLE error

I want to make a simple dashboard pie chart. I have a pipeline worksheet and I am setting up the COUNTIF formula but I keep getting the #UNPARSEABLE error. see the two screenshots.

I looked up the smartsheet error page and it gives some insites but I think I have all the pieces.

Any suggestions on what is missing?

Thanks.

Screen Shot 2019-11-13 at 11.00.19 AM.png

Screen Shot 2019-11-13 at 11.00.34 AM.png

Find more posts tagged with

Comments

Frank Falco

the values@row should be [Primary Column]@row unless you change the name of the Primary Column to values. There does not appear to be a column named values in your sheet.

You should also check the {Marketing Pipeline Test Range 9} bu clicking on it and selected Edit Reference. Sometimes the reference is not attached to the range especially if you pasted from another sheet. Not likely but work checking if the first option does not work.

Sign in to join the conversation!

Quick Links

Trending discussions

Template Downloads
Hi, I've watched number of training videos, specifically to set up PMO. I followed the instructions to download a template set, but it always adds it to a workspace, not the sheets folder. In fact if i download anything it adds it to a workspace, not sheets folder. What am I doing wrong?
Switching Rows and Columns for Reports
I have a sheet that has about 90 columns, but it might only have 12 rows. It would be easier to review reports if I could flip the columns/rows on the report and/or dashboard. Is there any way to do this? Even something using other views.
Moving Columns - Editors cannot share
Hi Brain Trust I have a sheet …hahaahah I have 4 editors cannot share - who in the last 4 days have somehow moved several columns to the back of the end of the sheet - we can see in the activity history that the reordered the columns - yet when we stand there and try get them to replicate it they cant How is this possible…