-
Include a form field with no option to fill in info?
Hi all, Is it possible to include a field in a form with no option for the user to fill in? For example, if someone selects something, I just want to give them an instruction, not have them provide any information. Here is the specific scenario: Is this budgeted for? Yes/No If No, then display text: Please confirm a budget…
-
Complex Form Logic Conditions based on Multiple Fields (AND/OR)
I really like that forms have some type of conditional logic, so that the users don't have to see fields that aren't relevant. But, it would be nice to add AND/OR logic. For example, the way it is now, conditions can only be based on the selection of a single field. With the addition of AND/OR conditions, we could combine…
-
Merged: Form Logic based upon answers to two separate fields
This discussion has been merged.
-
Merged: Multiple instances of a single drop down list in Forms
This discussion has been merged.
-
Dynamic Dropdown List on Form
I'm working on creating a form for travel document submission. They have to submit travel documents by specific trip number. I want to make the drop down list for trip numbers dependent on the division the select. ie They select Division A, they only get a list of trip numbers for Division A. Additionally I want to limit…
-
Dollar amounts in a form
I am trying to require a form field to only populate a number to display in a dollar format. I can only see the requirement of a number, but not an actual dollar amount. Is this possible in a form?
-
Form Submissions: Multiple Condition IF Formula Isolated to Most Recent Only
Hello Friends! I have a form that my field crew uses to check the condition of our machines every morning, which includes the most recent hour/meter reading. There are (5) machines that we own that I want to isolate the most recent reading into a dedicated cell in order to determine how soon the next service will be. Also,…
-
Smartsheet form + website data connection
Hello, I'm exploring the possibility of connecting a Smartsheet form to our website's content management system. Specifically, I'm interested in implementing the following workflow: A user accesses a Smartsheet form to propose updates to specific website content (e.g., a location description). The user enters the new…
-
We have two forms where data is being submitted but it is not transferring to the Smartsheet grid.
Something is amiss. We have received submissions from two Smartsheets where the data is not transferring. One sheet has 14 submissions and the other has 18 submissions. Where's the data? Is it lost for good or is it just out there in the data sphere looking for a place to go? This is the first time that we have encountered…
-
How can I capture the date and time of specific column changes?
I have created a workflow that goes through three different departments. I want to capture the date and time of a request (row) coming in, and the date and time of the next action and each action after that for cycle time purposes. Currently, I can track cycle time for dates but some actions need to be carried out within…