-
Tracking Activity on Form Links
It would be helpful to have some tracking on how many people are clicking on links for forms/open the form. We have surveys that are sent out to various partners and it would be helpful to know if the form is being looked at or not. Additional tracking could be on who has opened it (if required to log in to complete) or if…
-
Is there a way to send an Update Request to multiple contacts, but only accepting the first response
I am trying to put together some workflows where an Update Request is automatically sent out to a team of 3 people, but that only requires one response. I am hoping to avoid the unnecessary time/labor of more responses than are necessary.
-
How do I set up sequential Smartsheet forms that take in inputs from the output of the other?
Hi, I have set up Form A that will take in inputs from a group of users (Users A). These answers will be logged into Smartsheet A and that is working well. However, I have a problem. From the answers provided by Users A, I would need to populate one column (Project ID) from Smartsheet A/Form A as a drop-down list of…
-
Copied a form and combined answers
I created a form to invite people to an event and then copied it. The new one is for a different event intended for different people, but I couldn't find the sheet, yet the form is active. If I search for it by name, it doesn't show up. The answers I'm getting from the copy are being submitted into the first sheet with the…
-
I need to create a row for multiple names recorded in a form and duplicate the other cells
I use a form for group training, where there are multiple fields to add names of employees, but all other fields have the same answer for everyone. How can I create a row for each name when a form is submitted and have every other column (that is not a name) just duplicate the original's value? Getting this result can be…
-
Workapps access without logging in
Is is possible to create an app in workapps and have the users enter/edit information through reports without having them to log into smartsheets? I need users to provide input to specific action items but I don't want to have to set up a username and password to access SS. thanks in advance.
-
Show sheet data in the Form View
Our PMO is using Smartsheet to intake project requests from the business users via our intake form - which we love. However, once the project is submitted there is no particularly good way to have the request data that is in the sheet visible back to the business users (requestor, project owner, executive sponsors,…
-
Auto fill a second column based on a drop down selection using a form
I understand I can likely do this with a very, very long VLOOKUP or IF/THEN formula in every cell, but I'm dealing with over a hundred items and that will be unwieldy. Situation: I would like to have a form where someone selects one option from a dropdown of ~100 items. That value then populates into a sheet. (This seems…
-
Validate Email Domains
In a form, it would be great to be able to set up a validation that would not allow certain email domains (such as @gmail.com or @yahoo.com).
-
How to compare form responses with a list of emails?
Hi! I have created a survey/form and emailed it out. One of the survey questions asks participants to enter their email address. How can I compare their responses to the list of emails I sent the form to? I would like to create a report that shows who has responded and who has not based on the email addresses.