-
Automated calendar
Is there a way to create an automated appointment link like travel sites do once you book your dates? I created a webform for Time Off requests for our Sr. Managers. I would like to be able to send them a link to add the request to their calendars once it is approved.
-
Generate different predefined Gant charts, based on the parameters selected by user
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 these parameters. What should i do to create and design the smartsheet to get that…
-
Why are my radio buttons different sizes?
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 may be inversely related to character length of the response: choices with more…
-
Forms and Blank Rows
Hi, 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 temperature sometimes accidentally inserts a blank row into the sheet which results in…
-
Forms do not redirect, shows confirmation message instead
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 mode. No iframes. We have tried duplicating forms, creating new forms - all of them DO NOT…
-
Auto Fill form
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 deleting them, but we are wanting to keep all entries that have ever been typed into…
-
Splitting form data from multi-select field into multiple columns on sheet
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 indicator on multiple columns in the SmartSheet in order to use the data in a meaningful way.…
-
Creating a form with Multiple Logics
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. But I am getting this error. Is there a limit? Or is the error because I am selecting the same…
-
Can you validate an email address in a form by domain?
Hi, 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, and they would all have to be accepted for this to work. Is this possible?
-
Calculate total of each entry from multiple drop down selections.
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 find out the total number for each entry. When I put 'countif' formula, it only considers…