-
Separating data into separate rows, under the original an auto generated column number
My department has an existing SmartSheet, to track travel. This sheet autogenerates a number based off of a form submitted for approval. The issue is that in the form staff are able to list ALL travelers for the trip, which results in the names being included in one cell. However, I need to be able to have each traveler in…
-
Is there a way to restrict number input to positive numbers only in a form?
I'm building an approval process/workflow for a finance team and I'm curious if there is a way to restrict number inputs to positive numbers only?
-
Allow Re-Labeling of Symbol Fields
Please allow re-labeling of symbol fields. In a training survey I'm building (shown below), I would rather the values not say "Empty," "One," etc... I should be able to customize them to say what I want. Maybe not on the grid but at least when building out the form, similar to the way you can customize the label of the…
-
Adding a form which will allow Multi Row adds
Hi I have a need to set up a form to make life a bit easier and reduce email traffic. However i know 1 x form usually = 1 x row. My issue is when someone is requesting multiple dates, they need to be seperate rows. So the person requesting will need to fill in the sheet multiple times, is there a way around this?
-
Numbered questions on Forms
A way to automatically number form fields on Forms so that you don't have to manually update each form field when you add or remove a question.
-
Searching within a large dropdown list
Hello, I currently have an expense report for our company credit cards. On the expense report I have a drop down that lists all of the account numbers so that each line item can be posted to the correct account. There are hundreds of accounts and I would like to know if there is a way to broaden the search within the drop…
-
How to make my automated email only send once?
Hello! I am going to explain as best I can. So i have a automated system setup and currently i have where they fill out a form and it then auto creates a Fillable PDF. That gets sent to them which they have to get signed and re submit it into smart sheet. I have it set up where it send an alert which has the PDF and then a…
-
Survey Form Automation & Teams Integration
I've created a form for the HR Dept to collection employee appreciation submission. They want all submissions posted to the Team group. I was able to complete all the required ask except I can't figure out how to remove the link <GK Shout-out Submission Form> at the top because they don't want anyone to have access to the…
-
If there are multiple batch numbers, how can I make that go to different rows instead of columns?
Hello, I am trying to create a form that allows you to enter in when you receive different batches. Sometimes we receive multiple batch numbers at once. Is there a way to make it so that if multiple batch numbers are chosen that all the data will copy to another row instead of another column within the same row? Right now…
-
How to have only certain fields show on a form based on a condition
Trying to create One form where users can submit an enhancement request and based on the "Request Type" (a drop-down list), only certain fields will display and other fields will not display. For example, if a user selects Request Type = Report, then I want only report related fields to display. If a user selects Request…
