-
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…
-
Auto Add/Subtract to Inventory
I am attempting to create an inventory sheet for my business and was wondering if there is a function to automatically add and subtract to a number in a cell. Maybe something similar to say a button that +1 or -1 when clicked. If this is not available what would be the best way for my staff and I to updated inventory…
