-
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
-
Input form for multiple sheets
I originally had an Excel worksheet with multiple tabs. The first tab was an input sheet which fed into 100's of formulas in the other tabs. The other tabs (one for each country) used the values from the input sheet to do the numerous calculations. In Smartsheet, I imported each tab (input sheet and each country). I also…
-
Smartsheet Form - Latest entry is the only "actively" reported
Hi, I have a form for people to fill in that reports how ready they are for security. As this is evolving they can be expected to fill this in from time to time to measure how ready they are. So I only want the latest line from the form to be reported on. My system in place for this at the moment is to have a "Constant"…
