-
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…
-
Is there a way to change info in a master sheet to be reflected in sub sheets?
Hi all! 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 Sheet" where all of the registrations flow into. I have created "sub" sheets, and created work…
-
Update Request - Accumulated hours formula
Hi All, 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 who will enter the amount hours they spent on the task in the week just gone. I would like…
-
Automatically display the most recent text-based comments into a dashboard
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 into a chart nicely) and then can leave additional comments that I would like…
-
Emailing Forms
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?
