Discussions - Smartsheet Community

Browse Member Tips

HOW TO: Duplicate / Copy a Group
Smartsheet Support Documentation does not have a way to duplicate, copy, or export a group in admin.smartsheet.com/manage/groups There is, however, a workaround that doesn't appear to be posted anywhere so I'm sharing it here: Open the group in the group list at admin.smartsheet.com/manage/groups Select "View Group" Select…
Formula to add Months to Date
This is the simplest formula I can find to add Months to Date. This considers sum of months exceeding 12, converting it to January and adding 1 to the year. Where: Term column is the number of months to add, Date is the starting date. =DATE( YEAR([Date]@row) + INT((MONTH([Date]@row) + [Term]@row - 1) / 12),…
Pre-Filled Forms Using URL Queries: Tips and Tricks
Using URL queries to pre—fill forms seems to be catching on a bit more lately. There are a lot of resources out there, but they can be kind of spread out, so I figured I would start a thread that has some of the lessons learned, tips, and tricks that I have discovered along the way. Tip #1 [info callout] The first one that…

See all

Recent Discussions

Dashboard Image Widget Opens In New Tab
Create setting on dashboard image widget (and other widgets) that opens target in new tab. Often a dashboard is a landing page for a smartsheet ecosystem. I want to always have my dashboard available. Everytime I follow a link on my dashboard, I loose my dashboard, and have to open a new dashboard. Lets have the option for…
Set Up Links for Board View
In my grid view, I added a column that takes a hyperlink but when I mosey on over to Board View, only some of the columns appear as attributes displayed on the card. Can I make the hyperlink appear here?
Adding a link in the description of a card not working
When I add a hyperlink in the description of a card and save my changes, the link disappears and is not visible if I want to then share the card, has anyone found a way to get this to work?
Can SCC write Multiple Project Links Back to Intake Sheet?
SCC works great if you only have one destination to land on for your project link. Is there a way to create a second column to create a link to another asset that will be created as part of the toolkit? From the screenshot…I want 2 project link column inputs….
Enable Clickable Hyperinks in Smartsheet Forms (Android Mobile App)
Hello Smartsheet Community, We've observed that hyperlinks included in the "Form Description" and "Helper Text" fields of Smartsheet forms are not functional within the mobile app. While these links operate correctly on desktop browsers, tapping them in the mobile app yields no response. This limitation significantly…
Hyperlinks - Copying a Folder set where links stay with new sheets
Please tell me there is a solution for this.. I have a set of sheets, reports and dashboards. In one of the sheets there is a project plan and I've created hyperlinks to the relevant reports/dashboards within that folder. When I copy the folder, the hyperlinks refer to original sheets/reports and not the new ones. I've…
How to sort on a column where cells are hyperlinked?
I have a sheet and the primary column cells are hyperlinked to specific SharePoint documents. It works well for use with Dynamic View, etc. However, when trying to sort by this column it sorts by the "link to URL" address rather than the "display text". Sort is based on "https…." Is it possible to sort by display text?
Hyperlink to external site in automation message
Hi there - I'm sorry if this has already been asked - I'm having a hard time finding the answer. My goal is to include a link to an external site in my automation messages. For example, folks will come to our business and fill out an online form (through smartsheet). I then have the automations set to go to the email they…
Alert Automation: Links are not working on our Client's Email but working on others
Hi All, Our problem is not being able to click the Hyperlink we attached to our Automated Alerts. When we test it out on our side, it works. It also works for external emails/personal emails. My initial conclusion is this could be a security issue on their outlook. But I would like to know if anyone experienced this before…
Automated hyperlink URL within anchor text
In Smartsheet we are looking to build the following automation: 1. Team A fills out a form with client info 2. After form is entered, an email is sent to Team B 3. Team B logs onto the Sheet, and adds a one-time login URL to the corresponding client row in Column A 4. Team B clicks a checkmark under the "Send Email"…
Allow links to use "ms-word:ofe|u|" to force opening Word links in desktop app
To force opening MS Office links in the desktop app you can usually add "ms-word:ofe|u|" at the start of the link, however Smartsheet forces https:// at the start of the link. Please allow to use app URI schemes in the links to enable this.
Customize hyperlink destination in reminders/notifications
I tend to use a lot of large sheets with contributors from multiple sites interacting with the sheet through reports, and use automations to notify users when they need to input information in their report. Unfortunately, the notifications link back to the sheet itself and not to the user's report. It would be very useful…
Hyperlink manual trigger data shuttle workflow
As of now the data shuttle workflow can only manual trigger in the data shuttle page by clicking on "Run". My idea is to allow user to trigger running a workflow by hyperlink/webhook. So user can add the link in their dashboard as a function of Button. To manual trigger the data shuttle workflow when they are reviewing the…
Share a URL to a Specific Cell
I'd like to be able to share a link to a specific cell. by "Share" I don't mean grant access to a specific cell. I just mean I want to be able to Right Click on a cell and copy a URL to that specific cell. Then when I send the link to someone, IF THEY HAVE ACCESS, it will open the sheet and Flash that cell with a color…
Dashboard report links to open sheet at row
Currently sheet links from reports will open the connected sheet at the relevant row displayed in the report. When this report is added to a dashboard, this same link takes the user to the sheet, but not the specified row.
Is anyone else getting "legacy version" errors for all workapp content?
Yesterday our workapps got switched over to the "new experience" which is failing to load any workapp screens for users. All of the existing links we had built into our dashboards are no longer working, and instead users are directed to the homepage every time. I reconfigured the hyperlinks to the exact same pages, and the…
Internal Smartsheet Links
I have a sheet that lists all my my projects and one of my columns on that sheet is for hyperlinks to other internal smartsheets. These are sheets associated with each row's specific project. I would like the option to right click on those hyperlinks & "Open in New Tab".
A way to create a hyperlink for each rows attachment as a column
Hi Smartsheet Team, Is there a way to create a column in a sheet that is the hyperlink/link for the attachment of each row? I am using data shuttle to offload sheet data and the attachments aren't included in the csv file. I thought a link or hyperlink column would be a workaround for this. Any help is appreciated. Thanks…
Link to Individual Card View?
I want to display a card when a cell is clicked. Is this possible? I used the row link and hyperlinked it to a cell but when you click it brings up the entire grid in another browser with a border around the individual card. Is there a way to click a cell and have just that individual card pop up without sending you to the…
Clickable Links
How do I add a clickable link inside a message sent via automated workflows? I tried adding a link to direct the recipient to another sheet so the recipient can reply to a survey, but when the message arrived in the recipient's inbox, the link is not clickable.

Welcome!

It looks like you're new here. Sign in to post and engage.