Smartsheet Basics

Archives for March 2023

How to retrievie Submission forms?
We have a customer request form that customers can fill in for works requests. How do you retrieve the completed submission forms to print to place on hard copy records
Automation to extract specific lines
Hello everyone, Is there a way to extract lines using Automation? What I am after, is to extract the 3 lines marked, on trigger. Full lines is preferred. The 2 bottom lines are always "Fan Model" and Silencer type". Thank you everyone in advance for your kind suggestions. Wilson
Linking multiple projects plans
Is there a way to link multiple project plans together without linking each individual cell?
Automation to fill in existing cells
I have created an automation to set the status on our tasks. My automation is based on "new row is added or changed", then meets certain critiera, then a cell value is changed to a certain status. This works for rows I add after the fact, but has not updated my existing rows. Is there a way for an automation to update any…
How do I find the Source Sheet for a Form?
I have the url for the form, but need to locate the source sheet.
Aside from hidden fields, is there any way to tell in a sheet which form was used to submit that row
We use hidden fields a lot to send out various forms and write the data back to the sheet, but we had a snafu where a staff member forgot to update hidden fields on several forms, so now we can't tell what came from where...is there a unique id or anything that we can use to differentiate?
Has anybody created dependent dropdowns in smartsheet?
I'm looking to create a form that contains a few different layers of dependent drop down lists. I also want to grab the information on this form to generate a second document. Does anybody have any experience with this? TIA!
Filter by Form drop down list
Hi all, I have this Sheet And this Form I would like reach next thing: When in the Form I am selecting one value from "Vendor" dropdown list, the "Product" dropdown list will show only related values. For example: In "Vendor" was selected "iphone", when I will press on "Product" dropdown menu, I will see only "iphone"…
Linking Job Done Column and Completion Column
Is there a ready function that I am totally missing to link the Job Done column to the Completion column? I just want to set it up such that when Job Done is ticked, duration will automatically updated with 100%, and vice versa - that when completion is marked as 100%, the job done will be ticked. Thank you for any and all…
Automated Email with all assigned tasks
I have a client where we are using SmartSheet to track tasks. Each person with assigned tasks should receive a scheduled reminder to complete the tasks. Most of the users don't log into SmartSheet and don't have tasks most of the time, so asking them to log in and see their assigned tasks is problematic. I'm currently…

Trending in Smartsheet Basics

Is there a way to see if my sheet is being referenced?
I have a sheet I would like to delete but I want to make sure it is not being referenced or being pulled into a dashboard. Can I do that?
How to have separate data table for a new version of the form?
Hi All, I created a copy of the form I used so far, to ask a bit different questions and to collect the data in a bit different way. After the pilot stage I want to decide which version 1st or 2nd of the form will be used as the final version. But I see that the data punched into this 2nd version of the form are collected…
Auto populate name
Is there a way to auto populate a name based on what user checked a box? User checks an column, the column next to it auto records that user as the "checker"

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

Watch video

Smartsheet Basics

Discussion List