-
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…
-
Tracking form responses
Hello! We have an MOU form that we are sending out to a large group of employees. When we send the MOU out, we would like a way to track if someone has filled it out. What is the best way to do this? I assume you can use two sheets and compare so when they fill out the MOU, it can run it by the master list and mark if they…
-
More Error Checking on Forms
I'd love the ability to specify no negative number and/or only whole numbers in the number fields on forms.
-
Join columns from 1 match
Good evening, I'm looking for some assistance :) I've been trying to find the formula that alows me to join 3 columns value of the same line of the match. This is between 2 smartsheets. I made a quick draw of it. I would appreciate any help :)
-
NEW: Submit offline forms on mobile
Hi Community, Have you ever tried to submit a form on the Smartsheet mobile app, only to realize you had no internet connection? Whether submitting expenses on a plane or safety inspections on an oil rig, you need the ability to capture information anywhere! Now, the Smartsheet mobile app allows users to mark a form…
-
Offline Forms
Can anyone tell me if offline forms is available yet???? Cheers!
-
How to display "closest matching" rows based on an "input" row?
Hello all! I've been building out what is essentially a database to track information related to customer orders of a specific product. The product is essentially custom tailored firmware - specifically, automotive engine tuning files. Most of the information is provided by a customer through a form, some is manually input…
-
Prevent deletion of help text in forms when editing column properties
When editing the column properties from inside a form, if changing either the column label or the question type, any help text that the user has entered get deleted. While you can always edit the header in the sheet itself, it does not make much sense for longer forms that may have taken multiple drafts (questions…
-
How to count the number of times a value appears based on multiple criteria in another column?
Hello, I am trying to create a formula that counts the number of times an email appears based on a number of selections made from a drop-down menu. The process is for counting the number of trainings completed per quarter per employee. The trainings are submitted through a form and only one training title can be submitted…
