-
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…
-
Based upon the answer to a question on a form, can I direct to another form?
If I have a form and the 1st question has 3 options, can I use the logic to direct to 3 other forms so that the questions are relevant to the answer selected? For example, question 1 has 3 answers, A, B, C. If they pick A, they are directed to smartsheet form A, if they answer B, they are directed to smartsheet form B and…
-
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 Logic based upon answers to two separate fields
Would like to present a question only if specific answers are chosen in two other fields. Specifically if TRANSACTION TYPE field is "purchase order" AND EXPENSE TYPE field is "professional services", then display details about a required independent contractor form. A simpler, generic, example is if the first question is…
-
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,…
