-
2 forms 1 sheet
Hello, I have two forms in the sheet. Form A is the one to be filled out first. Form B requires some fields from Form A and other new fields. Form B needs to auto-populate some fields from Form A based on the contact list so If I select Peter in Form B, it should populate the fields from the sheet that Peter tagged and it…
-
Merged: Allow dynamic fill of dropdown in a form
This discussion has been merged.
-
Form will not allow attachments, gives error message and will not allow to submit.
We have a form for our online job application. We have a file attachment field on the form for applicants to attach resume. When they try to attach it and click the button to submit the form, it gives them an error message. It won't allow submission unless the attachment is removed. If it is removed, it will allow the form…
-
How to make a form add a new row each time it is completed?
I have a form set up with an automated request every two weeks. However, after the first time a user has filled out the form, the next time they see it they see the data from the row they created last time. How can I make it so that each time a user completes a form it adds a row to the table? I'm tracking progress updates…
-
Combining Form URL query strings in Alert Someone workflows?
Hi, I've got a sheet (Deals) which tracks the status of various deals and when the Status of the deals is marked as "Complete" it triggers an automation to send the owner an alert. The alert tells the owner they need to add a record to a different tracker (Live Deals) and includes a link to a Form to capture data for this.…
-
Incorporating Pictures on Forms
I am wondering if it is possible to add a photo selection in the Smartsheet form. For example, we are trying to create a patient satisfaction survey. We think it would be easier to show the patient/form user a picture of their doctor instead of the doctor's name. Is it possible to make a dropdown or multiple-choice…
-
Forms with Workflow
Hello Experts, I need to perform a requests and processing task within smartsheet. Needs some guidance to acheive this with the following requirement User comes with a new request to process files - Need to build a form The requests should be tracked in a sheet and I should be notified with status as Open - The requests…
-
Is it possible to over ride a formula when using Column Formulas
I have a sheet where new rows are automatically added to the bottom of the sheet from a form. I want the newly added rows to have formulas added to them, which I can accomplish using the Column Formula feature. However, I want to be able to over ride the formula in some cells. Specifically, a new row is added from the form…
-
Merged: Dynamic / Cascading Dropdowns
This discussion has been merged.
-
Merged: Smartsheet forms, logic for date dropdowns
This discussion has been merged.