-
Forms fail to submit, ending in unfixable error
Hello All, Students submit information via a form, and several to many have issues where the form cannot be submitted. There is no information missing. Closing the browser and resubmitting almost always works. Could there be something else at play? Timeout?
-
JOIN & CHAR and blank cells
Hi - I am joining cells in a row that may or may not be populated with data. I need to pull them all into a single cell to map to a document. I've managed to pull them all in using this formula: =JOIN([PF Employee Health & Knowledge]@row:[PF NSM Logs]@row, CHAR(1)) The issue happens with mapping. When a cell in the row is…
-
URL Responses in Forms
Is it possible to have an end user provide URL link(s) as a response entry in a form for one or more fields within the form, and then have the automation workflow email provide its live URL link(s)? Currently when the end user provides links in a field within the form, the automation workflow email responses come back as…
-
Autofill contact details
Hello all, I'm trying to create a formula to "Autofill" contact (Name, phone number & Email), What is the smartest, fastest way to create a formula for over 500 contacts? Thank you
-
Anyone have an idea on a way to make it easy for someone to submit a form multiple times?
I am using Smartsheet for colleagues to nominate others for their work using the form feature. However, most colleagues submit multiple nominations. I don't believe I can edit the autoresponder to include the link again, and don't want to add conditionals to the form for multiple nominations as this gets exported and…
-
Form not populating to sheet - please help!
Hi all, I built a sheet and form for an internship application I am coordinating. I have tested it several times, i.e. completing the form with test data and have not encountered any issues. I received a notification from Smartsheet this morning noting that I had a new submission - however, when I logged into the sheet,…
-
Send Form for Completion to Individuals with Pre-Populated Fields taken from Data in the Sheet
I have a sheet called 'Farmer Access Survey' which will contain the current data we hold on record for 130 farmers. I have created a form, which I want to send to each farmer to confirm the current data we hold, and collect additional information from them. Can I send a link to the Form to each individual in an Outlook…
-
Multiple users Forms - Conditional Logic not functioning
Hello, I created a form that is filled out by 3 parties. The user that initiates the form fills out the first portion than it gets to the second user that assigns the form to the third user that completes the last part. Everyone gets notification so the process works perfect from this point of view. The issues is that the…
-
How to create a survey that will track who has responded?
I need to survey a group of people and we require a 100% response rate. If I just send a link to a survey form out, I can't see who has not responded. I have figured out that I can load the names of the survey pool and use an automated update request as my survey, but the update form is extremely limited in formatting…
-
Can I conditionally expose a form field based on an earlier entry?
Okay, first attempt at explaining what I want to do.... I have a sheet where I track items (rows) with a multitude of attributes (columns). It's fairly unwieldy so I wanted to provide Editors with a form to submit new items. Current Form: User enters Title and Description (text columns 1 and 2), selects the Category from a…