-
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…
-
Auto-populating A Form Field
Hello, I currently have a form that asks users to select a product from a dropdown list. Is it possible to auto-populate the email address field so when a product is selected, the email address associated with that product automatically pops-up?
-
therapy caseload/client data tracking... anyone have success with smartsheet?
Hi all, I'm an Occupational therapist for kids with autism. After the pandemic rendered our therapy office paper data filing system obsolete(I couldn't access it from home), I determined to make the move to digital client records Smart sheet seemed like a user friendly option over excel I'm looking for a basic set up that…
-
Use smartsheet data to generate a document that maintains fillable blanks for the recipient
Use: We are using smartsheets to maintain client progress. We have forms that are pdf fillables mapped. We generate these and then email them to the account manager. At that point, the manager still has information to complete ie- other questions on the form that were formatted in acrobat pro to have fillable blanks that…