-
How do Link a Column w/ drop down items between separate forms/sheets?
I'm new to SS. This is my first project. I have an audit process I am building for a customer. There are 5 separate forms needed for the audit process. I originally had all 5 forms feeding the same sheet but with over 100+ columns for each audit, I went crazy scrolling left to right looking for the information I needed and…
-
Can I set a dynamic default value in a form?
I use a form to help my team record a log of completed work but I have an issue with recording the date. There's a date field on the sheet and I've added it to the form but I want it to default to today's date (whatever that may be when someone uses the form) and I can't find a way to do so. I can set a default value in…
-
Saving & coming back to a partially complete web form
I'm trying to create a web form that allows my users to modify the form that they have previously started. Ideally to save the form and come back to it before submitting the form. Is there any way of achieving this? Many thanks, Neil
-
Required Fields in Forms
I have a form created already, but need to make two existing fields "required". Does anyone know how I do this?
-
Populate data from notification center
I have created a form for one of my sheets, I am fine in getting alert when rows are added or changed. Can I crete a field on the notification and select the input data from the contact list? And the data I input will directly populate the sheet itself. I would like to add an extra field for the contact list. After I…
-
Adding a grid to a Form
Hello, I'm wondering if there's a way to add a grid to a Form to collect data when multiple names, emails and job titles are submitted. Currently we ask people to submit a PDF form to us that has an embedded table where they list the staff who have taken a training. The table headings are: Name, Email, Job Title. Sometimes…
-
Send form response
I would like to send/print my form with completed responses. Just sending/printing the row does not work, as the form has more information than the column names - is this possible?
-
Sharing Reports
Is there any way to share information on a report without giving employees access to the sheet it's connected to. This main sheet uses forms and may carry confidential information and I don't want them to view the full details of the sheet, just a few important key items on a report. Is this possible? This is in regards to…
-
SUMIFS based off Status and date?
I am building a counter for a team where they do a simple web form to say which task they did, and how many times they did it. There then needs to be a dashboard that then has a sum of that type of tasks completed during the current month, and the previous month (seperate). The FormData screenshot is the Grid that collects…
-
Capturing user/email addressing via form
Relatively new smartsheet form user here. Is there a way to create a field that would allow the entry of a name in one column and an email in a second column and have a user input multiple name/email pairs within a single web form? Essentially, we are creating a web form for training sessions and there are a number of…