Cross Sheet Reference Unparseable

I am trying to use a COUNTIF statement to reference another sheet and count the number of "V" s so I can create a metrics sheet for my DashBoard Creation. I have attached a snip of it below but all i get is #UNPARSEABLE when i try it. I must be missing something, but I am unsure as to what. Received the #INCORRECT ARGUMENT SET error before realizing i had to input the lookup set again to complete the range. So one problem down but still stuck with #UNPARSEABLE.

Find more posts tagged with

Manufacturing

Formulas

IT & Operations

Project Management

Comments

Mark Kapsa

Mike,

I am not sure as to why you are using a the VLOOKUP function in the formula. You would just need to select the column or range of the data for the COUNTIF function and then test that to count the v values.

=countif({SOP verification logbook range 2}, "V")

MikeCorvin

So i changed it to that, made sure it was referencing the same data set still, (it was), and all i get is #UNPARSEABLE as before.

MikeCorvin

Mark,

I was looking back at it and although I had set it up the way you had said i misplaced two characters and that is why i was still getting the #UNPARSEABLE error. Having walked away and come back to look at it I see where I got the isssue after trying to alter it.

TLDR: Thanks Mark!!

Mark Kapsa

Mike,

Is the data you are counting in a column defined as text? I set up a set of sheets and used this formula: =COUNTIF({New Sheet Range 1}, "V") and was able to return a value based on the text values of V in the data sheet.

Sign in to join the conversation!

Quick Links

Trending discussions

Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
Automation not triggering all of the time
Hi Smartsheet community, I've always tried to answer questions but this is my first time posting. So I have formula =IF([Project Status]@row = "Complete", 1, 0) set up in the "Complete Check - Hide column" to check the box when the project status is marked complete. The project status column is tied to several other sheets…