-
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…
-
How to flag the second largest date in a sheet
I have a sheet that collects responses from a form, specifically collecting status. I pull this data in to a second sheet to be able to show current and previous status on the same line. To do this, I am creating a helper column to flag the second largest date. I know how to find the most recent entry (largest date) using…
-
smartsheet forms
Hi all, is there a way to view who can access the smartsheet forms either through API or the website? We add people to our contact list and they can see the form at first and the second day they can't see the form anymore.
