Is character count in a cell is increased from 4000 per cell?

Amit Wadhwani

Hi,

I just wanted to know if the recent enhancements of smartsheet has increased the character count per cell?

I want to use nested if for around 70 products, satisfying each product name and I think that nested if is going to exceed the limit.

Paul Newcome

In your VLOOKUPS, try specifying the match type (last portion) as false for an exact match.

If you leave that portion blank or enter true, it will look for an approximate match instead.

=VLOOKUP([Barcode Number]@row, {Master Table Range 1}, 2, false)

Update this in each of the VLOOKUPS and see if that works for you.

Paul Newcome

I have heard that they are planning on increasing the limits, but I have not heard if it has been done yet or not.

Instead of a nested IF for 70 products, would it work if you could build out a table and then reference that? It would allow A LOT more flexibility in your products and your outputs, requires a MUCH simpler formula, and can actually be pretty easy to set up.

I'd be more than happy to help if that sounds like something you would be interested in.

Amit Wadhwani

Hey Paul,

That's a great idea, I tried to do as you suggested by:

A. Creating a table

B. Trying to reference the data from table via VLOOKUP function

but I'm having problem here, as only the data from first row of "Master Table" is being populated by VLOOKUP function.

I'm sharing links:

A. Master Table Sheet - https://app.smartsheet.com/b/publish?EQBCT=aeb6ee09d24148268af0f95745fe3c4a

B. Data Sheet - https://app.smartsheet.com/b/publish?EQBCT=98803d8ba2ab49f3b961d36ead4d3f9d

So Master Table sheet contains a "Barcode Number" for each product. Now in Data Sheet, what I'm trying is, when I enter the Barcode Number, it pulls rest of information(Product Description, Mfg #, etc) from "Master Table".

You will see in the Data Sheet that, I tried to enter different barcode number, but it still showed my the value of first row.

I really appreciate the help @Paul Newcome

Paul Newcome

In your VLOOKUPS, try specifying the match type (last portion) as false for an exact match.

If you leave that portion blank or enter true, it will look for an approximate match instead.

=VLOOKUP([Barcode Number]@row, {Master Table Range 1}, 2, false)

Update this in each of the VLOOKUPS and see if that works for you.

Amit Wadhwani

That worked! thanks Paul, appreciate it!

Paul Newcome

Sure thing. Happy to help. 👍️