Need Help - Formula to link to specific Site with ID number in URL from SS Column

LauraG5478

Hi everyone,

I am struggling to replicate a formula that I currently use in Google Sheets. We are a company who creates daily online puzzles, and a column (Column B) in our sheet has a manually-inputted puzzle ID number. Once we type the ID into Column B, Column C has an Array formula that then turns Column C into a hyperlink of the same ID as in Column B. See screenshot.

The formula we are using in Column C (with some URL info removed for privacy) is:

={"LINK"; ArrayFormula(if(ISNUMBER(B$2:B), hyperlink("https://squaredle.app/xxxx/#Id=" & B$2:B, B$2:B), ""))}

We would love to be able to replicate this into Smartsheet, so any ID number we input into the Primary column is populated as a hyperlinked ID in the second column.

Thank you in advance!

Darren Mullen

@LauraG5478 Smartsheet doesn't support that with a formula. Only way to do that is over the API after you create the row…