-
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…
-
Stop "reloading the same form"
When using the option "Reload the same form for another entry" in the Form Submission setting, there is no option for the user to get out of the loop without closing an additional useless form, which is confusing. There should be a way to get out properly. For example, why not have two buttons instead of the unique…
-
Does SmartSheet Allow User tracking similar to Google Analytics?
We would like to track the usage of Dashboards, Forms and sheets if it is possible similar to Google Analytics?
