Smartsheet Basics

Archives for June 2023

Forms URL query String, IS there a limit to how many queries can be used?
Hi, I am a novice with Smartsheet, but am learning. I have a form that I need to pre-populate so we can send it out to technicians to complete a field report. I can get five fields to populate, but no more than that. ="https://app.smartsheet.com/b/form/d2cda8ab647e4c11b40e503977eb916b?Part%20Number=" + [Part Number]@row +…
Loading dashboard in presentation mode
Hi, I have several dashboards that are all linked through clicking on different widgets. I would like them to automatically load in presentation mode, although I believe smartsheet doesn't support that feature at present. Are there any workarounds for this? Would it be possible to have say a web content widget and link to…
Hyperlinks to Smartsheet Not Working
This morning my hyperlinks in Excel that point to Smartsheet were working and this afternoon they are not. Now it goes to a tab in Chrome that tells me my browser is not supported. My browser is Google Chrome and it is up to date. I am logged in to Smartsheet. Doesn't work in Word either (but I didn't check that this…
Updating master data periodically
We have a Smartsheet that was created from a master Excel. Rows in this Excel change, and we have a process that creates an Excel with only changed rows, once every 24 hours. What is the best way to merge the changed rows with the master Smartsheet, automatically? Is Data Shuttle a product that can help with this?
Embedding a powerpoint in a dashboard
The instructions for embedding a pptx in a dashboard look straightforward. I've opened my pptx on the web and copied the embed link, but when I paste it into the Web Content Widget, I get the error "We couldn't find any embeddable content from this link. Please check the link and try again." I'm following all the…
Unable to attach PDF attachment to a Sheet
Hi, I'm having issues attaching a PDF file to a Sheet. I've tried clearing my search browser and cookies but it continues to fail uploading a RFP file to a row. Could you please help? Thank you!
Dropdown Based on Another Dropdown?
I have a list of all 50 states and the counties that reside within them in a sheet. In a separate sheet, I've created a dropdown for the state that, using data shuttle, references the list of states. Next to the state field, I have a county field which I would like to show the counties based on what state is selected. I…
QR code directing to Smartsheet form intermittently not directing to Smartsheet form
I have created a QR code for folks to scan to access a Smartsheet form to complete. Two out of 17 people who scanned the code received this instead of the form to complete.
Unable to display column chart and metric widget not showing value.
Hello Everyone, Column chart issue: I am encountering errors while attempting to display the column chart on the dashboard. The error message states, "Unable to display chart." The data source of the column chart is one report, and source sheet(Formula sheet) of this report is getting reference from another sheet. In the…
Request an Approval now has the sheet link, why?
Does anyone know how to remove the sheet link option at the bottom of the approval workflow? When was this added, and why? This workflow should be treated the same as the Request an update, where it doesn't give the option to the approver to access the sheet. OR If approvers need more information than what would…

Trending in Smartsheet Basics

Custom Report View
I have a report that is pulling information from a sheet. Is there any way to set this report up so that anyone that views it only sees the rows with their name on it?
How to do lookup for multi select dropdown cell to return results for all selected items in cell?
Hi I'm trying to do a lookup or index/match or whatever that can search all values in a dropdown list cell with multiple values and return multiple values. Sheet 1 screenshot (yellow highlight is where I want formula to be): Sheet 2 screenshot (contains table of lookup values): I'm trying formula from this question from…
IF logic formula
Hello, need help. I created formular for two outputs - "OTD" or "Not". See attached snip for details: A) Test 2 and 3 with date = Correct outputs, but for b) Test 4 without date = Same fx, still output "OTD" doesn't make sense. What do I need to do? C) For Test 1 formular seems working. But I'd like to incorporate into one…

Help shape the future of Smartsheet.
Share your ideas and feature requests.

Watch video

Smartsheet Basics

Discussion List