LINK

Silvina

Hi Community

I have a doubt about :

There is a way to set the link? I have to do it every time because the sheets are dynamic. There was a solution to link a entire column for example.

Thanks in advance

meagans

Silvina,

Hi! Are you trying to do a cross-sheet reference (linking one cell's value to another across Sheet views) or use a hyperlink that directs a user to a Sheet column within a Dashboard?

If it's the former, I recommend checking out this link in Help & Learning. Unfortunately, if you're trying to connect a specific column to a URL accessible on a dashboard, that is not currently possible in Smartsheet. I recommend using a Report widget or Dynamic View instead to highlight what you're trying to display.

I hope this helps!

Silvina

Hi! Meagan! Thanks!

I trying to do a cross-sheet reference linking one cell's value to another across Sheet views.

But in this way I did´nt find a solution. The link is just for a few cells. I want to link the entire column.

Andrée Starå

https://community.smartsheet.com/discussion/140782/link

Hi,

I hope you're well and safe!

You could maybe use the Cell-linking feature, or connect the sheets using cross-sheet formulas combined with either a VLOOKUP or an INDEX/MATCH structure. When you update the source sheet, the changes will be reflected in the destination sheet.

To connect them row by row, you could use an Autonumber Column in the Source sheet and add a so-called helper column to manually add the row ID on as many rows as you need in the Destination sheet.

More info.

Here's the structure for an INDEX/MATCH combination.

=INDEX({ColumnWithTheValueYouWantToShow}, MATCH(CellThatHaveTheValueToMatch@row ,{ColumnWithTheValueToMatchAgainsTheCell}, 0)

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

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

Make sense?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer! I appreciate it, thank you! 🙏

Paul Newcome

@Silvina The screenshot in your original post looks like a shortcut widget on a dashboard. Are you able to provide more details as to what you are wanting to accomplish? More screenshots would also help.

MelissaABM

Hello,

Building off of Silvina's original post, is the below syntax correct with the brackets and parentheses placement?

=INDEX({Service Partners | Company Name}, MATCH([Selected Service Partner]@row , {Service Partners | Selected Service Partner #}, 0))

Paul Newcome

@MelissaABM The syntax looks ok to me. Are you getting an error?

Andrée Starå

https://community.smartsheet.com/discussion/comment/489907#Comment_489907

Hi,

I hope you're well and safe!

Looks correct. Isn't it working for you?

If you're having issues.
Can you share some screenshots/information? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer! I appreciate it, thank you! 🙏