-
depanedant dropdown list in smartsheet forms
Hi all, as discussed here https://community.smartsheet.com/discussion/38196/dependant-dropdown-lists I am looking for the ability to have an depandant dropdown list in smartsheets forms. e.g. if the employee select his company only the associated departments should be shown to be selected. By the way, appsheet…
-
Sheet Summary CountIFS + Date Range
Hi All, Need some assistance. Found a great post & this on the subject but was not able to get my formulas to work. Hoping the group can help. I have 1 working the other is not. Background: Form was converted over from Google Form/Sheets & several formatting changes had to be made in August. (Probably issue #1) Co-workers…
-
"Unexpected Error"
Hi All, One of my colleagues has been experiencing an issue with approval workflows. When she goes to submit it she keeps getting "An unexpected error has occurred". I checked to make sure she is using Google Chrome and she is a fully licensed account. It happens to her so often that it holds up other workflows because she…
-
TimeStamp Formula Value
Hi, I would like to get a time/stamp value from a form entry onto to my master sheet , and have it reference the name of the person who made the entry. So for example, if I place an entry on the form, I need for my master sheet to match up my name and the time/stamp data and put it on my master sheet. Any suggestions,…
-
Edit Data on a Form
Hi - what's the best way to find out how to edit the data for a form? Some of our forms are populating incorrectly (Assigned To) but I can't access the original sheet. When I go to "Manage Forms" for the sheet I want, this form doesn't populate. This gets sent to me weekly from my manager, but the "Assigned To" names are…
-
No control over Form data validation
Hi all It's really sad to see that even if one has left one or more "required" / mandatory fields blank in a smartsheet form, they can still submit it! The SUBMIT button must remain disabled until all the "required" fields have received user input. Is there any option to overcome this problem please?
-
Anonymous form communication
Hello, I'm in a workgroup that is debating having a name required vs. not to submit process improvement suggestions on a smartsheet form. Those that want to have a name required want it so that people who submit can be followed-up with for clarity and those that want to leave an anonymous option argue that it is important…
-
Form entries are being added to the bottom of the column ?
I created a new form in the existing project tracker it created new columns on the right. When the form entries are coming in, its inputting data starting at row 356 all way at the bottom. Can the data input not start from from row 1 ? or is it because those rows 1 - 355 are being used in project tracker. Please explain &…
-
How to include a customer satisfaction feedback after a form is submitted?
We have developed a form recently for our Business scenario and we would like to add in a feature. I am not sure if it is existing as of now in Smartsheets. We need to send the user who submitted the form to fill an Satisfaction from scale of 1-5 along with smiles. May I know how can this be done?
-
Form - Copy of Answers
Hello, Is it possible for a form submitter to receive not just their answers, but also a copy of what they filled out? Our form has information in the question descriptions (not just the Q&A fields) that we'd like them to have a copy of. If they can't receive the whole form along with their answers, is it possible to add…
