-
Form stopped working
A form I have been using for weeks has stopped working, I've not changed anything on the form and the sheet. When I choose to send my responses I get an email with the data I entered but the sheet doesn't update. the sheet is empty at the moment so they aren't going to the top or the bottom and the count on the form for…
-
Logic based on multiple criteria?
Greetings- I have a form with drop-down input that allows multiple choices. Last options says "Other" which triggers the next input to appear if selected via logic. This works fine but if the users has more then one item selected (other and anything else, the next input doesn't appear. Any way to trigger hidden input if…
-
Generate an one time passcode for Form Submission
Hi Smartsheet team, I like to suggest to have a one time passcode for form submission as I like to collect information when needed and do not want user to share the link to others. As the request of info is going to use for exception request and do not want our users to freely share the link.
-
Rows being inputted randomly?
HI, I have a smartsheet form that connects to an intake tracker. However, when the form is submitted it moves the form data to random rows and now row 1. Does anyone know why smartsheet does this or what the solution might be? I need this solved quickly because I am creating this intake process to be handed off to another…
-
Duration Formula Help
Hello, I am trying to create two duration formulas. One is the duration is between request date and manager approval date and the other is the duration between manager approval date to admin approval date. All three of the date columns are the date column type. The date columns are filled in automatically by Workflows. I…
-
Help!! Deleted a sheet "Form" by mistake and its NOT in deleted items
I mistakenly deleted the wrong "Form" in a sheet this morning and it is NOT listed in my "Deleted Items" to restore. This "Form" link has been shared with our entire company so re-creating would be a major pain if i had to recreate, please tell me it can be recovered?
-
Hello is there a way to restore a deleted form by accident?
Hello I deleted a form by accident, I know we can revert sheets and other items but there is nothing for forms. Does somebody know if there is a way to recover deleted forms today?
-
How do I enter Contact List details into a Form?
I want to be able to enter the Name and Email Address components into a Contact List column type field on a form. Is there any way to do this? Or even to create a formula in the Sheet that will calculate the Contact List value with display Name AND Email Address, not just one of the other. Otherwise, please Smartsheet, can…
-
vlookup issue and multiple selections
I'm using a form to collect headcount changes at locations we manage. I'm using a vlookup to autofill the site managers name based on the site location chosen. However, I've run into an issue when the person filling out the form selects more than one location (selected via drop down multi-select list). If the headcount…
-
Convert SOME of the blanks to zeros
I am creating a new sheet, and so far, about 30 columns. Of these columns, 12 are metrics which require a numeric value. I would like to create a Workflow to convert the blanks in ONLY these 12 columns to 0. It is likely that some of my other columns will be blanks, but I do not want them to be converted to zeros. If…