-
Smartsheet Forms Updating a Sheet
Hello, I am not sure if this is available but I am looking to do the following. I have a Smartsheet with individual elevator numbers, name and location. There are about 85. I am seeing if its possible to have a drop down on the form which the inspector will choose the elevator number and the name and location will self…
-
Prefill Contact Field using URL query
Hello, I've tried every trick and formatting option possible to prefill the contact field on a form using the contact field from another sheet. The contact list looks like the screenshot below. The true field name in the sheet of Product Line Manager is PLM I've tried ?PLM=Kevin%20Hietpas%20%28khietpas%40email.com%29…
-
Clinical Trial Identification Tool
I created a form where providers can enter medical history to determine if a patient may be potentially eligible for a clinical trial. The sheet containing the form submissions has columns with cross-sheet formulas that match the patient's history to clinical trial eligibility criteria listed in another sheet. This is…
-
How to add a formula within a form that auto populates based on values filled out in other fields?
I need to include a formula in a form that shows a percentage based on values that a user will input when filling out a form. I need to do this because other questions on the form will depend on the value of the formula. For example, My form has these two fields: Original Contract Amount & Change Order Amount I then need a…
-
Form Logic Erased
I developed logic based on a form selection dropdown. The form had been saved, but whenever I opened the form today, the dropdown selection field in the form was blank (but the smartsheet still had the options). Whenever I went to test the form, all of the logic was gone. Is there a way to restore a previous version of the…
-
Can you create update requests with Current User filter capability?
Good morning. We are trying to send a workflow update request to an employee that will then update a tracking sheet — however, we do not want to share the sheet with the recipient, nor do we want the recipient to be able to select the Go To Sheet link at the bottom of the update form (which I understand cannot be removed).…
-
Creating a form without a workspace
From the homepage we used to be able to create a new form and it would be added to the generic sheets folder. Now when I go to create a new form it creates a "new solution" which creates a whole new workspace every time. If I just want to create a form without adding a workspace, how can I do this?
-
Clear buffer on a form after use
Avoid the form from saving your information when clicking a field.
-
Modify an existing line via forms?
Hi-can a form be used to modify an existing line instead of adding a new line if the form is generated to request a change? Thanks
-
Is there an easier way to reorder fields in forms?
I have a very complex intake form with lots of conditional logic and dividers, headers, etc. I need to reorder major sections of the form. Dragging and dropping the fields is painstankingly slow as I wait for then form to scroll up to the section I need to drop it to, all the while scanning for the right column - is there…
