-
Nested Form Logic?
Good Afternoon Smartsheet Pros! I am trying to create a form that adds new employee data to a spreadsheet. My desire is that I have functionality that allows the form filler to add multiple personel entries to the same form. My instinct was to create an 'Add Additional Employee' checkbox with logic that populates the data…
-
Calculate a date in a form
I have two fields in a form: Request Type and Due Date I need to calculate (or perform a vlookup to another sheet) if the date that is chosen dfalls within an agreed timeframe based on the Request Type that is chosen. i.e. if Request Type = Email AND Due Date is less than 5 days from the submisson date then show a SLA…
-
How to loop a form back to the start after hitting Submit
I created two forms, one ends in Yes/No (not required) the other in a file drop (required.) The form ending in a file drop loops back to the start requesting new data after hitting Submit while the other form just sits there showing the "Success" message after submission. I moved the file field to the end of the…
-
One time use of form
Hi! I am still creating the pre-onboarding checklist using the form. However, one roadblock for me is that the user can use the link multiple times. Is smartsheet capable of limiting the link to one time use only? Like, if I answered the form already and then I click the link again it will show a message of "You have…
-
Adding comments to approval process
Dear smartsheet-community, I am using the approval process for new incoming projects. Basically if a new project/line is added, an approval request is sent to 15 team leads and their choice (confirmed, declined, pending) is stored in 15 columns representing the 15 teams. Question: Is there any way to include a…
-
Forms: how to move some column data to a new row
Hello, I am using a form to collect HR job / position requests. The upper portion of the form collects administrative information, the bottom portion collects position and financial information. The problem is that people often want to submit more than one job. The current state requires them to open the link again and…
-
How to Add Specific Field into Form with SUBSTITUTE Formula
Hey Community, I am trying to have my OPPTY # field prepopulated in my form using the SUBSTITUTE formula because a lot of our users tend to enter it incorrectly. Can you please help me figure out how to solve this? I will paste a screenshot of the format below.
-
Viewing attachments in a new tab
Hello, I have a form with an option to attach an image file directly form a mobile device. That image is then saved as an attachment, but when I try to open it, a new window pops up called "Preview File". The saved images are quite big and this window doesn't have the necessary tools, to enlarge or to inspect them. I don't…
-
Fields Will NOT Add to Form After Completing Formula
I recently had a Pro Help desk call to figure out how to add a pre-populated field to a form. We got it working easily and I will paste the formula below (we added the Work Order ID field to the form because it tends to be filled out incorrectly). =FormLink?Work%20Order%20ID=" + [Work Order ID]@row I tried to write this…
-
Limited User For Forms
Hi there ; i would like to ask that when i create a form , everybody who i share link , can open this form.I want to limited this situation and want only that people who work with my account can open. IS it Possible ?
