-
How can I connect multiple sheets into 1 master sheet?
I have multiple sheets, each populated by their own form. I would like each sheet's columns imported into the master sheet and populate the same row. Is that possible?
-
Automatically capturing the name/ user who completed a form
I have created a form that needs to capture who filled it out. Currently I am having the person fill in their name. I am wondering if there is a way in forms to have the person automatically capture? That way they don't need to fill that in.
-
Make input text fields in form enlargeable by the user
Hello! I am using a form and have various input text fields. I want to let the user enlarge the input text fields as they want to be able to view all the text they have written at once. I know there is an option to adjust the height of a multi-line text box but it's not exactly what I want as the user doesn't have access…
-
Can multiple form entries populate one row?
Use case: A team lead submits a form reporting a start time for a delay in work, giving information about the delay and crew members involved. Later, the team lead submits another form reporting the end time of the same delay. Is it possible to have multiple entries populate the same row so the team lead doesn't have to…
-
What is wrong with this COUNTIFS formula?
=COUNTIFS({Consumer Alerts Sign-up Form Date}, >=DATE(IF(MONTH(TODAY())>=7, YEAR(TODAY()), YEAR(TODAY())-1), 7, 1), {Consumer Alerts Sign-up Form Date}, <=DATE(IF(MONTH(TODAY())>=7, YEAR(TODAY())+1, YEAR(TODAY())), 7, 31), {Consumer Alerts Sign-up Form Range 1}, @cell = "") I am trying to create a COUNTIFS formula for each…
-
Providing email response to submitter of a form
I want to set up an automation to email data collected in form to the person who submitted the form (I collect their email in the form).
-
Smartsheet checkbox automation triggers email notification to email in field
Hi Smartsheet Smarties! I need your help! I have a Smartsheet with a form that people fill out requesting time off, including their email. There is a checkbox (not included in the form) that is to identify management approval. I would like to set up an automation that would email the person who filled out the form (field:…
-
Form Managment tool
Hey, Is there a form management tool? I have a sheet with over 100 forms and I need to make the same change in all of them. Is there a view like a smartsheet sheets of all the forms so I can edit them more easily? Even a list view would make it easier so I dont need to see the photo of every form. Thank you
-
How do I know who submitted a new entry using a form.
I added a system column "created by" in my sheet but when an entry is entered using a form, the created by cell populates with "web-form@smartsheet.com". Is there a way to get that cell to populate with the username of the person completing the form? I know I can add a column "submitted by" and make that a required field…