-
Export SS form conditional logic?
Hey there, Is it possible to export the questions and conditional logic in a form to some sort of flow chart etc.? I have a fairly complex form and need to document, but looking to avoid building a flowchart myself manually. Thx, Willie
-
How do I fix a VLOOKUP problem?
Hi there I'm using a form to capture COVID RA Test results, scheduled for different departments on different days. The schedule uses a VLOOKUP to populate the 'test result' column from the form results and allows us to report on anyone who was scheduled to submit a test by a certain time but hasn't (report if blank &…
-
Email validation for Forms or Workflow conditions
Is there a way to do email address validation in Smartsheet forms or in Workflows? Using condtions such as contains '@' or '@domain.com' isn't sufficient and I can't alert form submitters that they did not submit to the form correctly.
-
Using a fillable PDF as a form to fill in Smartsheet
Hello, I am looking for ways to use fillable PDF (attached) as a form to fill out Smartsheet. Similar to how a form is generated in Smartsheet, is there a way for a fillable PDF to be used as a "custom form?" Each field can be defined and mapped beforehand to the corresponding smartsheet and "submit" would update the…
-
Can there be a character limit to a text field in a form?
And if not, do you know what the character limit is by default for a multiple line text field?
-
What kind of template can I use for tracking new hires as they learn different jobs?
I am looking for a template that allows employees in training and conducting training to report their progress, a notification system that alerts me to concerns raised, and an end dashboard I can use to easily summarize progress and complete further planning. Another goal is to create a sort of plan for each trainee in…
-
Error when submitting a form
Please what can be the reason for this, form was submitting fine yesterday
-
Form response is skipping rows on the sheet
Hi there, I have a form that was created from an issues tracking sheet but when the form is submitted, it's entering the information several rows below the next available row. The sheet is set up to auto-generate the Row ID. Does anyone know why this might be happening? thank you!
-
Field Settings Resetting the Help Text in a Form
I just created a new form and added a "Do you agree to the Terms & Conditions" Field Name. I put the Terms & Conditions in the help text. After doing that, I edited the field name and after doing so, the help text disappeared. This also happened when I first saved, then edited. I propose not clearing/resetting the help…
-
Automation: Email with Set Frequency Until Cell Value Changes, Trigger Date Re: to Form Submit Date
Hi! I have a form being used as a ticketing solution for marketing requests. When users make a submission, one question is, "Have you provided all information?". Answer options are, "yes, begin with creative" or "no, more information will be entered later in Smartsheet". So long as cell value is "no, more info will be…