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…
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 p…
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 …
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 Fi…
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 …
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.…
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 …
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 document…
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 widge…
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 …