-
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…
-
How to prepopulate a form using the row as a reference?
Hello, I apologize for the simple question. I am a beginner with Smartsheet but I have not found the question answered in the help sheets. I would like to prepopulate a form answer using the row as reference. I can get the form to prepopulate but I have to enter the address manually in the formula each time. I have…
-
Images in a Form
Is there a work around to add more than 10 images to a form?
-
How to autopopulate % Complete based off of other cells entry
Hello, I am trying to autopopulate % complete based off of other cells YES/NO entries in the sheet. I have 5 criteria to determine if we get to 100% Completion or not: Columns: Paperwork Received - YES (add 20%) NO (add 0%) Samples Received - - YES (add 20%) NO (add 0%) HPCL Received - YES (add 20%) NO (add 0%) Hold…
-
Direct a new form to an old form URL
Hello All, I'm moving to a new sheet with different column headings and different information. I need to keep the old one. I know the workaround will be to save a copy of the old sheet for my archive and use the original sheet to build the new one. But I'd like to start from scratch (in fact, I already have!). I would like…
