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

cell link to another sheet doesn't update
I have a cell link to another sheet. ( links are generated from Control Center) On several occasions, when the timeline date changes (source sheet), the link to the summary sheet does not update. When you are in the summary sheet and you double click on the cell, the source sheet pops up showing the correct data (date) ,…
Can not move my sheets/reports between folders
Im trying to create new monthly duplicate folder with all shared links we are using for our data project , for some reason i can not move sheets and reports between folders , only to workspace that not commonly used by us Anyone is facing the same , your support is appreciated Thanks in advace
send custom form links using automation
Can i generate a custom link to another form with prefilled content from another sheet? When someone completes a form i have an auto number that counts up on every submission. This is our reference number. When someone completes the form to generate the row i want to use that reference number to send an email with a form…
Is there a quick way to identify or List all the Smartsheet Links?
Hi There I have a worksheet that I have inherited, and need a way to identify all Links from a cell in other sheets. Is there a report of function on Smartsheet for this? Thanking you in advance for your assistance. Warmest Regards Dickson
Approval Requests: No link to sheet?
Is there a way that the link to the smartsheet isn't included on the notification to an approver - but they still receive specific data/information from the sheet? We only want the approver to see what we assign to them and not the full smartsheet. THANK YOU!
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.
E-mail Dashboard with active links
Would like the ability to e-mail a dashboard with active links where the dashboard image is imbedded in the e-mail vs it being a link.
FORM Links - same link moved to different sheet
It would be a great idea for tracking and traceability purposes in sheets, to have the kind of on and off button that allows the same form link to be associated with different sheets. Meaning that lets say i want to start a new sheet each year, but i want to keep the form link to be the same. This can be overpassed by the…
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…
Make notification links open in desktop app?
I use the desktop app along with Microsoft apps (Office, edge, etc.). Is there a way to make it so when I click on Smartsheet links in emails/teams chat that it will open the desktop app vs edge? thanks,
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…
Approval Request - link expatriation
Hi, I'm in the process of setting up a system for gathering approvals and I'm curious to know if the approval link included in the automated email has a set expiration date or if approvers have the flexibility to access the link at any time to cast their vote.
Mixed Sheet Structure
I have a Sheet where users enter tickets for Enhancements to current applications. These could be any type of requests and there are several steps necessary prior to approval to start work. There are two types of enhancements that when approved are 'tracked' on a different log, though specific fields updating the primary…
Links in dashboard freezing
Over the last week or 2, I'm finding that dashboard links 'freeze', ie. stop working after some time, ie. maybe 20 minutes or so after dashboard opened. This is happening with dashboards via the desktop app, and with Chrome and Edge browsers. Once it's 'frozen', as I move the cursor around the page, the links are 'dead',…
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.
Windows Animations
Discovered a new issue with smartsheets recently if you are a user that doesn't like to see windows animations. If you have the path below checked to "No" smartsheets works significantly worse when having the attachments pane open on a smartsheet (or report) and smartsheet links directly to a row takes you to the top of…
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…
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…
Getting Outlook to Open After Clicking Email Hyperlink in Dashboard
Hello! I am making a dashboard and am using a Rich Text Widget to include relevant contact email addresses. All of the emails I included appear as hyperlinks in the Dashboard and the actual links include "mailto:" followed by the intended email address. The formatting is correct, however when I click on the hyperlinks…
How to include new form links for newly provisioned projects?
Goal: Have links to included forms update to the newly created forms (same as sheets, etc.) when generating a new project folder via control center. I was under the impression that this would be possible once forms became searchable objects in Smartsheet. I tested in a dashboard and 1. Was unable to find forms in the…

Welcome!

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