-
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…
-
Dynamic View Logic for Required Fields
Hi there! I have a dynamic view created for Event Approvers to go in an Approve or Decline events. Depending on whether they approver or decline an event, I'd like different fields to show in the details panel as required in order to save the approval status update. However, the fields are only showing up as required after…
-
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,…
-
Workflow Automation Wait Logic
I'd love for the ability to add wait logic, which would be added somewhere in the middle of an automation, which would wait for certain criteria to be met before moving to the next stage. This could allow for my current process, involving a series of eight different automations into a single one, waiting and checking on…
-
Intake form should be and have more dynamic flexibility on setting multiple logical criteria
The Smartsheet intake form foundation lacks so much dynamic functionality and does not meet other applications minimum standards when it comes down to setting couple or logical multiple criteria on when a question should show/hide. I tried many ways to set up a logical criteria where if a user selected option 1 for the…
-
Using Data Fields to Automate New Forms
Hello everyone! I am building a data tracker sheet that will track event data sourced from a form that goes out to event coordinators. I'm trying to figure out a way to push them a 'new form' to fill out when they select that they have multiple events they need to submit. Ideally, I would like to automate this process…
-
Automation works correctly when manually changed in sheet but not when input through form
Hello, I created an intake form for a project request. In the form there's a field where the submitter has to select from a dropdown list of Contract Information choices. Here are the automation logic I have: When I tested it by selecting the different options in the dropdown in the sheet column, this works correctly.…
-
Why is the branching logic in my form not working?
I have logic set up in a dropdown field that says if this field contains X, show the Y field. My issue is that the Y field is showing regardless if X is selected from the dropdown or not. Anyone know why this is happening?
-
Can logic be added to a sheet?
My boss wants to create a sheet that includes 4 different profile forms. I'm curious if this is even possible. Basically, we have 4 different excel docs that are profile forms, we want to try to combine these forms on a grid in Smartsheets but we want the fields to auto populate depending on which profile form is selected.…
-
Conditional Formatting for a Modified By Column
I am trying to create an automation or formula to populate a cell. Here's the gist of what I am trying to accomplish: Only when a completed box in a column is checked → I want to populate another cell in that row with the Current User who checked the box. I would like this to populate automatically through the use of a…
