I would like to create a tool that creates different Gantt Charts based on the 3 simple parameters chosen by the user.
As a user I want to fill a form where answering to 3 simple questions I get the correspondant Gantt chart according to t…
Using Smartsheet9Sergio Mola
I've created a form to collect survey responses using radio buttons so respondents can select one answer for each question. The radio buttons are inconsistent sizes across and within questions. It looks like the size of the radio button …
Using Smartsheet14Annie Martin
We using a Smartsheet form to capture Covid19 Screening Questions. Once submitted the person has their temperature recorded which is manually captured against the record.
The problem I am experiencing is that the person capturing the …
Formulas and Functions14Lyn Pringle
One of my clients have +50 forms.
After conditional logic update for forms, several of them stopped redirecting and started showing "confirmation message" instead. Forms are working since ~2017 unchanged and are used in plain mod…
Hi, I would like to build forms with default minimum and maximum values and I would like the form to send me an email only for the values which are out of range. The min and max will be mainly numbers for different equipment. If the out of…
Using Smartsheet23Smartsheet User
I have a sheet where I am tracking construction progress. There are a lot of data/calculations that my field personnel do not need. I want a simple interface for them to update data (% Complete, Actual Date Completed, etc.) Each…
Is there a way to set smartsheet to remember ALL entries in a form so that you can start typing in the field and it will narrow down the selections as you type? It seems like smartsheet will only remember the last 5 entries and then starts…
Formulas and Functions17RNelson
I am trying to use SmartSheet to send out a form to vendors that allows them to select choices in a Multi-Select field. I then need to have the choices the vendors selected in the multi-select field split out into a binary type of indicato…
Formulas and Functions26Kyle Wefler
I have a very large worksheet - almost 80 columns wide. Of those, about 20 are formula "Only" columns where personnel will not enter data.
I would love to use the same form, select from the drop down and the fields auto-populate…
We have a web form with a place for a respondent to enter in an email address. We would like to restrict the field so that only domains from state government agencies can be entered into the form.
Each agency has a distinct domain, an…
Using Smartsheet20Jessica Hodge
I have a database which is filled by clients through form. In Area column, the clients will update the area from their house where the issue is located. It is multiple selection. Screenshot attached.
In my metrics sheet, I want to…
Formulas and Functions18Abhiraj Joshi
New to Smartsheet so please bear with me and my (maybe perhaps)silly question but one I haven't been able to find a solution to. I am using Smartsheet to compile online student registrations. My format: I have one "Master Shee…
Formulas and Functions20Alex Zylka
I have a field called Number of Children in my form. The user then inputs the number of children they have. What I am looking to do is have other fields added based on what the user input for the Number of Children field. For example, if t…
Using Smartsheet25Michael Richard
Currently I am setting up a tracker for tracking weekly hours spent on requests that come in via a form.
I would like to set up an update request that runs every friday (until task is marked as closed) to the assigned person w…
Formulas and Functions29jg124
I understand I can likely do this with a very, very long VLOOKUP or IF/THEN formula in every cell, but I'm dealing with over a hundred items and that will be unwieldy.
I would like to have a form where someone selects one op…
Formulas and Functions2379Dajah
Does anyone have any guidance of how to take a response a form that could be several sentences and feed it into a dashboard preferably chronologically?
I'm setting up a survey where volunteer rate their experience at an event (which fits…
Using Smartsheet18Brett Kennedy
Is there a way to have the Form embedded in an email so the person does not have to open or click on a link. But instead can fill the form out in the email?
Using Smartsheet31Kimberley Harris
I have two similar INDEX formulas, where one works and the other one retrieves #INVALID VALUE error.
They are as follows:
"IF([Nov-19]188 = 0, 0, INDEX($[Jan-19]$119:$[FY50]$119, 1, [Nov-19]188))" - this one works and retr…
Formulas and Functions34Jose Vale
Is there a way to collect automatically user email information into a form submission ?
Thanks in advance !
Using Smartsheet19John Witczak
I am trying to create a form where every student is scored under the same category all at once. For instance, I have 15 students; all 15 students will be scored on 12 categories each day, with a possible score of 1-5 for each student on ea…
Using Smartsheet30Reed Vial
We all love a Freebie?
OUR API development team get lots of requests for automation which is the basis of our Smarter Mini Control Center 12 Apps, but one request we have been unable to fulfill so far (unless we use Appsheet with Smartsh…
API & Developers1262Richard Rymill SBP
We're using multiple SmartSheet forms within one sheet to record steps for various equipment to be started up, with each piece of equipment requiring responses from multiple parties and usually to be filled out over the course of time as i…
Using Smartsheet23Kate Clelland
Hi, I am trying to create a form based on a list of where for instance, one account has different line of business only applicable to that account, I would like these to be shown once the account is selected from a drop down menu. I was th…
In the new "proofing" system, is there way to use a form to automatically send a file to "proofing" rather than to just upload the file? I can't find any method of getting a file into the "proofing" system oth…
I am working on creating a form for stakeholders to complete that will populate a smartsheet that we've had in place for several months. This would create efficiencies for us and help our stakeholders as well. I want to be able to do the f…
Formulas and Functions22D Gray
Hello community, I'm new to Smartsheet and have a few questions for using the Forms.
I have a survey questionnaire with 20 questions.
Is there a pagination feature in Smartsheet that lets me break the long form into several pages? It's a …
Using Smartsheet21Amy Zhong
I have a sheet with more than 10 columns and the webform does not seem to allow me to capture columns beyond the tenth one. When setting up logic in “field settings” under the “then show the following fields” drop down only the first 10 co…
Using Smartsheet18Dean Arvan
I am new to Smartsheet and have seen nearly all of the training videos, I work in I.T. Cybersecurity and wanted to get your opinion on how to create a Smartsheet(s) for looking at installation, failures, dates, etc. for I.T. disk dr…
Using Smartsheet18Terrence Logan
We have a bid invite sheet that we fill out with prospective jobs (each row is a prospective job) to bid on. It has multiple columns of Data that if we decide to bid on the job would need to be transferred to our sales/esti…
Hello, I'm having trouble understanding what function I should use to do lookups when there is more than one matching value. I know how to use vlookup, at least well enough to know it won't work in this case. Here's what I'm trying to do:
Formulas and Functions60joelmold