-
Help with Update Request
I am asking leaders to fill out a form for promotion nominations with 3-5 contacts/emails for stakeholder feedback. My hope was to automate a request to each contact once the leader had submitted the form. Each stakeholder would get an update asking for: a yes/no on support, reasons to promote, and blockers to promote.…
-
Transfer data from one sheet to another
I know SS has the "move to another sheet" or "copy to another sheet" but sadly it does not look like you can do that and have "cell links" from the blank form that you are going to copy data to , to do other items. Does anyone do any copy / pasting that is advanced and would have some suggestions? Here is what I am doing…
-
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 &…
