-
Smartsheet Forms
I have 60 people that have submitted interest, and now their details are all on my SmartSheet having used the forms function. I'd like to email them with another form to fill out, but would like it populated on the same sheet, next to their original entries. Is this possible?
-
"Iterative" Formulas or Loops
Hello everyone. I am having an issue where I do not see a way to make any of my formulas iterate any specified number of times, let's say similarly to a "for" loop in a programming language. I am curious if there is a solution I am overlooking or if this is not currently doable with Smartsheet. Please see my example below,…
-
is there a way to view a sheet in the same window as a "modern" theme form?
I have a form, using the modern theme, that requires the user to enter a unique numerical code associated with a project, as part of the project's approval process. Is there a way for the user to see the sheet (or part of it) that contains the list of these codes, so that they dont have to go searching around the dashboard…
-
Can a Smartsheet form populate a PDF, and then send that PDF to Slack
Hi My company has a logistics driver that delivers sets to theatre. He usually fills in a paper form of what he has dropped off and then takes a picture of that and posts it on Slack. We have decided to move over to a paperless system and have made a smartsheet form to track which sets are delivered. Each time a new row is…
-
Combine Multiple Form Fields into one column
We are using a form to enter new customer information into a smartsheet file. Our key is a formula setup with multiple columns combined to create the unique key, since some of our customers work for the same company out of the same office location and we need to be able to search by all. Is there anyway to combine in the…
-
Can Smartsheet lock a column AFTER data is input, for referencing in Update Requests?
Hi, I have a Smartsheet workflow I would like to implement and can't seem to figure out if it's possible. I have a sheet with four columns: Name, Date (formula set to the following Monday after the CreatedBy date), Commitment Detail (a work task they are promising to get done), and a Commitment Completed (yes/no dropdown)…
-
Mobile App - Help with viewing public dashboards and favoriting forms
I've created a dashboard with several links to Smartsheet forms we use. I've published the dashboard and shared the published link. All of our employees have the Smartsheet app on their work phones. When they click on the published link to this dashboard though, it opens it up in their mobile browser, rather than the app.…
-
How can I copy information to a new sheet to create a log?
I'm trying to see if there's a way to have data copied from a few specific columns to a new sheet. I'm hoping to create a log for IT issues as they occur on requests. The difficulty is setting some sort of trigger that will move the information over into a new row whenever a new issue is added. The other possibility, would…
-
Logic Issues on Forms
Hi is anyone having issues with conditional logic since the smartsheet down period 1/22? I cannot add a heading to conditional logic anymore.
-
Auto Pouplating Form Fields from Active Directory?
Hi there! So, I am in the process of creating a request form for our users. The goal of this form is: The user enters their first/last name, their email address, their department/job title, manager email The user fills out the type of request needed i.e: new laptop, cell phone, software license, etc.. The request gets sent…