-
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 ?
-
Assigning Contact Based on data in another sheet
Here's the rough scenario. I have 500 students who are divided up among 20+ teachers. When I choose a student in one column, I want to auto-assign their teacher in another column. I do this in Google Sheets with a formula, but wasn't sure how to go about it here. Let me know if you need more clarification. Thoughts? Gillian
-
Documents in Forms
We use a Smartsheet form to keep track of students rotating through the hospital, which includes them uploading various documents we need from them. We also need them to fill out a few of our documents and attach them to the form. Is there a way to host/link these documents within Smartsheets? Or do we have to link to the…
-
can forms have totals?
I want to add to a form a section that asks people for amounts and then totals it, is that possible? something like: blue widgets needed - # red widgets needed - # green widgets needed - # Total widgets = # blue+# red+# green