-
Forms
Is it possible to have a user complete a portion of a form and then route the same form (with data) to another user? I know the 2nd user can go to the sheet and populate the remaining data; however, I was hoping it could be on the form. Thanks.
-
How to get multiple form entries into the same row...?
Hi everyone, I am looking for help regarding how Smartsheet forms populate rows. We are currently using Smartsheet to complete our annual employee evaluations, which consist of three sections, one for the employee, and two manager sections (completed by two different people). We initially had the employee fill out a…
-
Automatically HyperLink URL that's pasted into a form
Hi Smartsheet community. I am trying to figure out how to directly link a URL (pasted into a form !!) to a cell with the exact same hyperlink click-word for that link type. Let me explain the situation better: My company has a sort-of project database spreadsheet to keep track of "leads" or projects that could progress…
-
Can you alert/send an email to contacts in a cell that have been entered via a form?
I have my alert settings to Unrestricted, but even so, it seems those who fill out our form cannot be notified since they are not users of SmartSheet. I am looking for a solution other than the "Send me a copy of my responses" option. TIA! 😁
-
automatic email of completed form to submitter
Is there a way to automatically email the submitter their completed form information instead of relying on the user to select to email a copy of their submission?
-
How do you make a name input on a form become a contact that is already a contact in Smartsheet?
I posted this on an old thread, but thought it might be easier to find as a new entry. I am trying to have a contact show up in cells based on input on a form. User fills out form with account manager name. For example, Rachel Alexander. Rachel is in my contacts. However, when the data from the form populates the sheet it…
-
Attach a pdf flyer to form submission
I have setup a Dog Registration form for residents in town and I want to automatically send each submitter a flyer. We are required by the State to do stormwater outreach regarding dog waste (see attached). There doesn't appear to be a way I can include a document in the Form Settings "Send Email of Submissions". Is there…
-
Formulas from Forms
Hi there - I have created a form with 4 questions that has dropdown (multi select). In the smartsheet itself, I need formulas for the following: If all boxes are checked then show 0 If only 2 of the 4 boxes are checked then show 10 Please help, thank you!!
-
Report on cells that only contain data
Hi, I have a form that asks many questions on values for ordering stock. There are 20+ columns, which is quite difficult to report on. The user will only tend to use 5-10. Is there away to design a report that only looks at cells that contain data? Many thanks Gary
-
Forms for employee surveys
I am planning to use Forms to complete an all-employee survey of approx. 16,000 people. The link will be shared during an all-employee webcast and the post webcast communication. Will there be any issues if thousands of people click on the link and try to complete the survey at the same time?