-
Autopopulating Dates Based on 2 Fields
I'm struggling. I have a workflow to auto-populate the created date. I have another column that determines the type and length of review requested (3 days, 6 days, or 12 days). I would like to auto-populate to a specific submission date Mondays at Noon to be discussed at a recurring meeting on Wednesdays, so it would be…
-
How to apply cell formula to new rows added by form.
I have a cell formula to apply to the row 1.. I need new form entries added to top row to automatically apply. The form entries are the amount of dollars or change turned in to get total amounts by count. I can not make it a column formula. please advise. I tried using Absolute ($) but it changes row # with every new entry.
-
Can you set up logic in forms that have a start date?
Working on a project that I need to add form logic to but don't want it to start for a week? Is there a way to have a start date in the future OR will it only start once added?
-
Form not using logic despite being set up.
Hi, I have set up a form which will be filled out whenever a machine encounters a downtime period and have set up certain logic to show questions depending on the previous answer. For example answering 'Machine' with either "EMZ 3612" or "EMZ 3610" will show the 'EMZ Downtime Type' question and so on for other machines. I…
-
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).…