Linking Columns

Hi all

I know there have been a number of archived discussions around linking an entire column from one smartsheet to another, and that it can't be done. I know that there is a workaround by selecting a column and changing the cell background to white, and then linking the"blank" cells, and this works fine.

I have a sheet with a pulished Form for staff to fill out and register Health and Safety hazards. In this form I have an Auto-Number column that will populate a new value for each new form filled out.

However, if I use the cell background trick above, (ie select 50 cells in a column and change background to white, then link to another sheet), the next entry from the form is added to the sheet BELOW the white background cells!

Any thoughts on how I can get the cells in an Auto-number column to link to a different sheet, especially when the number of entries goes beyond the default 50 rows?

TIA

Vance

Find more posts tagged with

Accepted answers

Andrée Starå

@Vance McMillan

I've sent you an email. It was a weird email address, so writing here as well to make sure that you see it.

Let me know if you haven't received the email.

Have a fantastic weekend!

Vance McMillan

Hi Andree

Thanks for helping with this - I see that you've corrected the attempt I made to use your suggestion, and it's now working. That's fantastic, thank you so much!

If anyone is curious, here is what Andre suggested:

Because you're already using one Autonumber column for the Ref in the Source sheet, I'd suggest that we add an Autonumber column to the Target sheet (RowID) and start the number from 551 (or the number that makes the most sense). Then we'll remove the cell-links in the Ref column and add something like the below formula.

The rows that match will show, and on the other rows, it will say #NO MATCH, or we can change it to something else.

=INDEX({Source - Ref}; MATCH(RowID@row; {Source - Ref}; 0))

Regards

Vance

All comments

Andrée Starå

Hi Vance,

You'd have to use cross-sheet formulas instead.

Either VLOOKUP or a combination of INDEX/MATCH.

https://help.smartsheet.com/function/vlookup

https://help.smartsheet.com/function/index

https://help.smartsheet.com/function/match

Would that work?

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

@Vance McMillan

I've sent you an email. It was a weird email address, so writing here as well to make sure that you see it.

Let me know if you haven't received the email.

Have a fantastic weekend!

Vance McMillan

Hi Andree

Thanks for helping with this - I see that you've corrected the attempt I made to use your suggestion, and it's now working. That's fantastic, thank you so much!

If anyone is curious, here is what Andre suggested:

The rows that match will show, and on the other rows, it will say #NO MATCH, or we can change it to something else.

=INDEX({Source - Ref}; MATCH(RowID@row; {Source - Ref}; 0))

Regards

Vance

Andrée Starå

@Vance McMillan You're more than welcome!

Glad we got it working!

Ramakrishnan S

Is the Linking of One Column to another is not yet resolved? do we need to work around this achieve? if there's a solution, kindly point me to that page. Thank you. @Andrée Starå

Andrée Starå

https://community.smartsheet.com/discussion/comment/480849#Comment_480849

Hi,

I hope you're well and safe!

Currently, you have to use a workaround, but soon it will be possible without one.

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Awesome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.