I am unable to import links in specific cells while uploading data in smartsheets from excel.
I cannot use row level attachment feature as I have links in multiple column
Answers
-
Maybe a little more info? Are you doing a one-time import or a Data Shuttle import? Are you importing cells that contain "https://something.com" or cells that contain "My Link" and a defined hyperlink for "My Link"?
-
I am trying to import excel that has specific cells with embedded hyperlinks
-
Hmm.. I just did a quick test with a sheet that had both "https://google.com" as the text in one cell, and "Google" as the text in a another cell where "Google" was hyperlinked to google.com…similar to what you have above. On a one-time import, both cell came in as hyperlinks.
Note that import will bring in the hyperlinks, but won't attach them to the row. Attachments and hyperlinks are two different things, and you cannot attach something on an import.
You can use the API to automatically create attachments if you have a tool like Bridge available. For example you could use Bridge to read the hyperlink from the import on the row, and create a Link attachments to that URL. Here's the API endpoint for that:
https://smartsheet.redoc.ly/tag/attachments#operation/attachments-attachToSheet
-
Did you try uploading the excel (.xlsx) file with these hyperlinks to smartsheets? When I import from excel, I only see the text and hyperlinks are gone.
-
Yes, I did Create…Import from Excel.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives