Is it possible to link a column from one sheet to another?

Hey @RonH

Try changing your [match type] from 0 to false

=VLOOKUP(“<search item>”,{Table Name},<column number>, false)

Does that work for you?

Hey @RonH

Not seeing your exact formula, I will give you this one. Remember you will have to physically insert the cross sheet references into your sheet - you cannot simply copy paste. I changed the names of the ranges (which is a good practice) to clarify what column I was referencing. In the Index/Match function you use individual columns as the specific range, not the entire table range as in vLookup.

This formula would go into your customer Status column

=INDEX({internal sheet Status}, MATCH([Item Number]@row, {internal sheet Item Number},0))

Does that work for you?

Kelly

Ok, let's work on the NoMatch

Just to verify - the row on the customer sheet where you put in the formula - it does have an actual match in the other sheet? In other words, on that row, there should be a match.

Assuming yes there should be a match, is it possible that you can give me screenshots of your two sheets - I'm really only interested in seeing the data the columns listed above. Don't share sensitive info like customer names, etc. Also, if you can take a screenshot of your actual formula - I'm interested in seeing the colored text.

Once we get the formula working properly we can take care of the legit NoMatches when they show up.

As we work, if there's anything you don't understand, don't hesitate to ask.

Kelly

Hey Ron

Let's see if we can get this working for you.

Thanks for the screenshot - it is always so helpful for anyone in the community that is helping with a question. To verify - your {Development Planner RM Status 7} is a single column that would match your answer in your [Tracker Number] column?

I'm wondering if smartsheet thinks the data in one column is text and the data in the matching column is a number (this is assuming your item number is a number and not alphanumeric textstrings). Often you can tell by looking at the columns in both sheets, assuming you haven't manually formatted the justification. If one is left justified and the other is right justified, then one set of data is behaving as a number and the other as text. Not knowing what the [Tracker Numbers] look like in either sheet, I'm guessing at common possible causes. Let's try this

=INDEX({Development Planner}, MATCH(VALUE([Tracker Number]@row), {Development Planner RB Status 7},0))

If that doesn't work, delete the reference to {Development Planner RB Status 7} completely from the formula and go back in and re-insert it from the formula dialog box. You wouldn't believe the number of times I've found an error in what I thought I inserted.

Kelly

Hey

No, that shouldn't have anything to do with it. Can you show me a few of your tracker numbers in both columns? I don't need to know what they are linked to - just to see the format of your data. It would be good to see lines where the same data exists in both columns.

Is the tracker number data being hand entered or by formula in that source sheet?

That actually is good news. Please delete the reference {Development Planner} from your formula. Through the formula wizard, click Insert reference and select the correct column. Before click the Insert into Sheet, remember you can rename that Range as a good practice. Hopefully the re-insertion will clear up the wrong column data being inserted.

Once the formula is working as it should (and only after the formula is working as it should) we can make the NoMatches go away, if you wanted them to. Or, if desired, we can make it say something else. We always do this step last after making sure the formula is working properly since this step masks any errors the formula is producing. Two reasons would drive you to mask the NoMatch. One is to clean up the appearance of the data. The second is that these errors can sometimes cascade through to other calculations, causing calculations to not execute.

Let me know what happens after you do the first step of deletion, reinsertion.

Kelly

No it doesn't matter in this case but it's always a good check on dropdowns - you could get possible errors between single select and multi-select columns. So it's good it's not that.

I have to back us up to the NoMatch. To verify, the row you are sitting where there is a #NoMatch does have a match on your Development Planner sheet and your {Development Planner RB 7} refers to the entire column and not a single cell.

Is the Tracker Number of Development Planner sheet entered manually, or by formula?

Kelly