How to import an MS EXcel sheet, with embedded links in cells?

srinis

srinis ✭✭

03/25/22 in API & Developers

How to import an MS EXcel sheet, with embedded links in cells?

0 ·

Answers

Intern98 ✭✭✭

03/28/22

Convert all embedded links into text in excel,
import to SS and change it to web Link in the options

0 · Share on Facebook Share on Twitter
Gia Thinh ✭✭✭✭✭✭

03/28/22 edited 03/28/22

Hi srinis,
Just using "Import Microsoft Excel" menu as below, then all the embedded links in Excel cells will be there in your new Smartsheet sheet.

Gia Thinh Technology - Smartsheet Solution Partner.
0 · Share on Facebook Share on Twitter

Categories

Trending in API & Developers

URL String - Any common thread between Sheet and Form?
Hi there, I came across a circumstance where someone had a link to the form but forgot where the sheet lives. Is there anything within the URL of the form that can bring you to just the sheet? I tried cutting out the 'form' from the URL, but unsuccessful. TYIA!
Newly Received 404 with Error Code 1006 on DELETE sheets/{sheetId}/rows API with ignoreRowsNotFound
Hey there, Was a recent breaking change pushed to the smartsheets API? Previously, when calling the DELETE Request to the rows endpoint, I would receive a 200 with a valid response. Now, when requesting a valid sheet, with a valid row, I am unable to get a 200 response and am only receiving 404 with error code 1006 in…
When I Copy Workspace, Everything Copies Fine Except for CellLinking
Hi, Using the API documentation, I'm able to copy entire workspaces which has been great for scalability. I've been noticing that the only thing that doesn't work correctly out of all the sheets, reports, and sights, is the cellLinks in my sheet. In the instructions, you can tell it all the different things to pull in. I'm…