Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Hi
I have a column with a long URL http://blblblblbl... There are about 300 rows in the sheet. I'd like to change the display text of the links to Preview for all of them.
Is there a way? I can not do this one by one. (multiple sheets with the same set up).
Thanks
Hi,
There currently isn't a way to change all of these URLs to include display text across all of your sheets all at once in a batch update.
You might consider updating one cell with the display text and URL, then drag filling down or using copy and paste (ctrl + c and ctrl + v) to make the change on a sheet by sheet basis. More info on these methods can be found in the help center: https://help.smartsheet.com/articles/518318-using-copy-paste
Staubm,
I think I know your problem, and have a way to fix it. If I understand correctly, you want to display the friendly text for the url "GoHere" instead of the full hyperlink "https://123.mrsupercalifragilisticexpialidocious.com/home/GoHere"
Here are the steps: (takes about 5min per sheet)
1. Export your Smartsheet to Excel and format all of your hyperlinks the way you like them. Save it as .xls
2. Do a Save-As on this Excel sheet and save it as file type .html
3. Open the .html file in a web browser and do a Ctrl+A to select all, then Ctrl+C to copy.
4. Open a brand new .xls file and paste into the new .xls file. Save
5. Import your excel file into Smartsheet and then copy/paste your column from the imported sheet into your original sheet. Voila!
Don't ask me how I figured that one out. It was frustration and luck
Hi all, reaching out to see if of you have ideas; I'm hoping this makes sense: I'm having some trouble getting my formulas to pull data in correctly. I currently have a sheet (primary data) where I have data in rows where each row is a single project, with columns identifying persons, $ values, unique project identifier,…
Hello, I have a workflow where, when a team member checks a checkbox, Smartsheet automatically sends an email to themselves containing merge fields that are used as a customer email draft. The challenge is that this activity typically happens on a deadline day, and a team member may need to generate 30 or more of these…
I have a sheet with 5000 rows and 30 columns. with 4 columns of them are formular columns. How can i reach this limit for 25000000 formular cells reference? How can i enlarge this limit? I need those formular to link some data from another sheet as there is also Max cells limit for one sheet. How can I join those data…
