-
Automatically Include Current Date in a Form Field on Templates
I have a form I use for data collection. In one form, it has a start date which would always be the current date. I cannot find a way to have the template always use the current date the form is generated. Instead, I have to edit the form each time I use it to add the current date, then make sure it is hidden on the form…
-
Auto Date on Forms
Does anyone know how to have a template form automatically use the current date? I have a form I use for collecting data and it has a start date, due date, etc. I would like it to automatically use the current date as soon as the Smartsheet is generated from the template. Is that even possible? TIA
-
In-House QR Code Generator
I've already shared this idea with the development team and they liked the idea, but I'm curious to see how the community would receive this as well. There seems to be more and more users in the Smartsheet community that are using QR codes with forms. It's not a difficult process with so many free or paid QR code…
-
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).