-
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…
-
Dynamic Forms created as an Object
It would be great to have forms created as objects, that way if I copy paste a folder, or am provisioning projects via control center, the form URL will be dynamic to the newly created object instead of me copy/pasting/modifying dashboard links etc.
-
Project Management with Multiple Subprojects
Hello! I'm looking for recommendations on the best (aka easiest) way to create and manage subprojects within a project. Our current systems are set up to have 1 project number, 2XXXXX, with several subproject numbers, 3XXXXXX, depending on how many phases and shipments of the job there are. The subproject numbers are…
