Formula looks good but getting blank return for data in the RO # field / see below

I have made a sheet referencing data from another sheet. I am having this sheet (29th street) pull the LOC (location) and RO # (Repair Order #) from another smartsheet where that data is already populated.

This is the formula:

The cells above and below fill in the data with no issues. Here is the reference sheet:

But this is what the sheet is showing, and the formula was just copied to all cells in that column.

Any assistance would be greatly appreciated.

Find more posts tagged with

Accepted answers

SSFeatures

@Davisc8 Haha yea that definitely sounds like a bug.

I'm glad it's working now!

Best!

All comments

SSFeatures

Hi @Davisc8, I think that the reason why it's showing up as blank is because there's an error happening for that cell, but your formula has an IFERROR telling it to return "" in the case of an error.

Can you remove the IFERROR from the formula, so that we can see what kind of error is happening. That will make it easier for us to debug the problem?

Then once we figure out the problem we can add the IFERROR back in.

Also, something that might be helpful in the future, rather than copy and pasting the formula to each cell, you can convert the formula into a Column Formula by right clicking the cell and then clicking "Convert to Column Formula". This way there's less likely to be a mistake compared to manually copy and pasting the formula.

Davisc8

Here is the cell with the iferror removed:

And I am not actually copy / pasting the formula as I am dragging the formula from the top cell down to where I need it to end.

And here's the formula without the iferror

Thanks in advance for your assiastance..

Davisc8

Actually - I messed that up - sorry - when I take the full iferror out, including the end, it is still just blank - no error:

So no error showing …

SSFeatures

@Davisc8 this is really weird. It works for every single row except for that one with 2413. Is there anything different about that 2413 row? Does it have extra spaces in it or something?

Just to help us debug this, what happens if you reduce the formula down to just:

=MATCH(TAG@row, {PERFECTION YARD CHECK TAG}, 0)

The problem is either in the INDEX part of the formula, or the MATCH part of the formula, and I'm guessing that it's probably in the MATCH side.

Davisc8

Well this is weird. It's returning 166.. It's on line 165 - condescendence ?

This is the reference sheet - top line is what should be being referenced

Davisc8

Sorry,

Had these in there but must have deleted :-)

Davisc8

And now I copied the formula down from the cell just above it, which is how I originally got the formula in there, and now it is returning the correct RO #'s as it should ….. We'll call it a bug :-)

SSFeatures

@Davisc8 Haha yea that definitely sounds like a bug.

I'm glad it's working now!

Best!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.