-
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.
-
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…
-
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.
-
Workaround for prepopulated form having query string cleared when user is not logged in
I maintain an internal web app which has a button for generating a form in smartsheet. It does this by building the query string containing required data in the hyperlink on the page. If a user clicks this button, it opens a new tab with the prepopulated smartsheet, user clicks submit. All is well. But if the user is not…
-
Form logic process: view all options in the "then" field
in the "when...then" logic flow, ability to view all options in the "then" field (if it's a drop down or multiple choice), even it there is no intention for additional columns or fields.
-
Reminder automation
Hi! I'm trying to set up an automation for weekly reminders if certain conditions are met / not met, and from what I can tell everything has been entered correctly, yet when I run it to test it seems to fail. Any help is appreciated! Here's a description of the situation and what I have set up: Several farmers markets have…
