-
Default form date to Today + constant
I am creating a form that un licensed users will use to submit requests. I want the default for the form to be Today + 4 business days. Is this possible? It looks like the default date can either be hard coded to a specific date, or set to Today. Any help would be appreciated!
-
Use Today's Date by Default in Web Form
I've created a task list which I enter tasks via a web form. I have a Date Entered field in the web form. I would like to make this a hidden field in the web form and by default enter today's date into my task list when I submit the form.
-
Signatures on Forms
I was wondering if there was a function that I could you use to sign forms? I have staff of about 80 who need to sign that they have received Tools of Trade like mobiles. At the moment we are doing this with paper, which gets lost - would love to be able to set up a smart sheet and have everyone saved in the same place and…
-
Locking a Form from further editing after a specific date
Hello, We create forms for volunteer events. We are running into the issue where people are signing up until the very last minute. Is there a way add a deadline to the form or lock it? Or disable the form link. Thank you
-
Data -> Exported Form
Hello, I am relatively new to SmartSheets but I am looking to place a form we have now into smartsheets to collect the data there. However our Executive Team likes the look of the original form... Is there a way to export data in a way other then in a grid/ excel looking chart? Id like to customize it and have it run only…
-
Dashboard
Hi, I want to report on the number of form submissions in a dashboard - can anyone tell me if this is possible? Many Thanks
-
Forms: Text box inserts based on select answers
Hello community, I am using a form as a survey and am trying to use a "If yes, please explain what/why" option. Is there a way to pose a question on a form with a Yes/No answer and can select based on which of those answers will add an additional text box to another column or so? Appreciate any input or ideas people may…
-
Export Web Form
Hello. I am trying to use SmartSheet as a relacement for an audit form. There about 90 questions on the audit that would be answered with a selection of A, B, or C. Ideally, those would be checkboxes, but the sheet does not allow duplicate names in the columns. I would like to be able to pull a clear report from the data…
-
Automatically marking something as complete when requirements are filled
Hello, I was wondering if someone would be able to help me with a problem that I have been struggling with. I would like to make it so that when a checkbox is checked, in another column, called status, that it would switch and say complete. The status column is a Dropbox, containing Completed, In-progress and Not started.…