Can Bridge add the "Row Link" to Cells?

Cory_OWA

My users maintain inventories which interrelate to each others' rows. They administer all new rows by inserting the Row Link into the Primary Column cell's text as a hyperlink (<link url=Row Link>text</link>) so that, wherever the row is index matched into another sheet, the user can navigate across sheets to view the index matched row and back.

Can Bridge run on these rows and automatically insert that Row Link address as a Hyperlink, triggered by row creation?

Or, if inserting the hyperlink is too dangerous (if say, the cell already contains a web address like "Google http://bing.com"), write the Row Link (https address) to a column? Then, I can use a formula to bring it into the Primary Column cell.

jmyzk_cloudsmart_jp

@Cory_OWA

Yes, you can.

In the published demo sheet below, if you add a row by adding a value to the "Add a row" column, a Bridge workflow adds row links to the "Primary Column" and "Row Link" columns.

I used "Get Row" to get the row link in the workflow by including "Row Permanent Link" in the advanced options. Then, I used "Update Row" with the row link information, {{states.Rows Added.smartsheet.get_row.row.permalink}}, as shown in the Sheet Summary.

https://app.smartsheet.com/b/publish?EQBCT=e53916eb9f5f4c9fae372cf5ac21327b

Cory_OWA

@jmyzk_cloudsmart_jp - thank you. Your post is very generous.

Do you know if it's possible to wrap the "Add a row" column data with a hyperlink, using the Row Link column data as the SRC for the hyperlink?

jmyzk_cloudsmart_jp

Hi @Cory_OWA

I could "wrap the "Add a row" column data with a hyperlink" by using the "Advanced Cells" as shown below. (I changed the "Add a row" column's column type to the "Text/Number".)

Updated Demo Sheet

add row link to a new row - Smartsheet.com

Advanced Cells settings at Update Row

Cory_OWA

Brilliant!