-
compare multi-contacts to a text string
Hi everyone, I am building a schedule for my team that will confirm if a combination of assigned staff 'assigned to' are trained to do a specific task 'task combos'. the 'staff trained in this task' is a text column that is using JOIN(COLLECT) to combine contacts who are trained in a task, these are in different columns…
-
How can I add days to a date field within a logic formula to output a true/false value for a chkbox?
My objective is to create a new column where a box is checked once the row meets desired criteria. The checkbox will help me filter-out rows that will be synced via a Salesforce Connector workflow. The logic criteria is as follows: "Overall Status" = Blue (complete)….and…. "Working Launch" Date + 7 Days </= Today's date…
-
Total Hours with the same person assigned
I have created the below sheet. I am trying to total the hours used for rows matching "person" E.G In the first row "Richard Irwin @ FM" I'm looking to total the rows below Project Staffing that have Richard attached to it in the column "Person" Any ideas?
-
Forms - With Conditional Logic - Not working
Okay first I used to set these up for Medtronic, np, but my previous employer did not have Smartsheet, so I am out of practice (AND using a personal account). @rrenee tried to help before, but something is not working. Let's go simple. I set this CL based on selecting 1 of the many reports in the Report Category list. What…
-
Form Logic
Hi! Needing help with conditional logic within a form. So, I built a form for Training, Travel & Development Requests within my organization. With that, I have built in approvers (the associate chief operating officer is a drop down to select the applicable approver). What I want the form to do is: When a submitter selects…
-
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…