-
Doing things first time right with data validation
In a productive organization, the most efficient method for cutting waste is to attack anything and everything that is not done right the first time. The only drawback to SmartSheet is its ability to manage "data validation" like excel does. Even with column properties set as Date, users can still write stories "text…
-
Restrict field to numbers only
I apologize - I do think this should be a basic question that I could answer myself, but I cannot. I am new to Smartsheet so still learning. I see that you can set a field to Text/Number, but how do I restrict a field to only allow numbers to be entered? it's a field for a customer ID - that if someone attempts to type…
-
using external data in a form and sheet and for validation
Our company has an internal application. I would like to reference this application's data in a form and in a sheet: * When a user is submitting a form, it lets them select a value from a drop down that is populated from data in this external application * When a user is submitting a form, it lets them enter free-form text…
-
I need to restrict access to a web form to only a specific group, can I do that?
I am using Smartsheet as a project list and a web form as a work request system. I need to restrict access to the web form so only spefic people can file a request. is that possible?
-
Date Submission in Form
Hello! We have a form that is collecting a Date Submitted. For the date drop-down in the form, is there a way to disable dates that are before today's date? We don't want the user to be able to select a day that pre-dates today's date.
-
URL method to send information directly into a Smartsheet?
(Total noob with SmartSheets) I’m using Smartsheet URLs in an LMS training course at the end for feedback and suggestions. Currently we construct the link inside the course and it opens a web form when clicked with some of the fields pre-filled in based on user info from our LMS. It’s good to insure they don't have to type…
-
Enable Confirmation Email: Add Asterisk
In order to continue the good work you've done on Forms UX, I suggest that when a user checks "Send me a copy of my responses," the form's subsequent "Email address" field label could be followed by a red asterisk, similar to all other required fields on the form. The client-side error-checking is nice with its red border…
-
Can approvers of Smartsheet forms be added without giving access to the sheet?
I am creating a form in Smarthsheet that will require two levels of approval is a particular question is answered in a certain way. In the form they manually enter the email address of the people who are required for approval. I am finding that if I do not share the sheet with the person I am seeking approval from I cannot…
-
Forms
OUr forms are randomly requesting participants to complete a CAPTCHA request, however, we have not added this to our account and if it is going to show we want it to happen with every form submitted and not just random few. How do we correct this?
-
How to create report with rows instead of columns?
Why does Smartsheet only allow you to make a report with columns and not rows? I'm using my sheet to coordinate data for events. Each row has a specific event, each column has different details for the events (date, location, hotel, meals, etc) and I need to take information from only certain rows to create a report for…
