-
Does reordering columns impact any other existing logic? The column title would remain unchanged
Does reordering columns impact any other existing logic (datamesh, formula, workflow, helper columns)? The column title would remain unchanged. Specifically, is there any reason this could impact a helper column using a formula that references the column being reordered?
-
Is there a way to logic-trigger different custom labels/descriptions for the same field?
Is there any way to set up logic in either Dynamic View or Forms so that the trigger displays the same field but changes its custom label? I am building a solution for a performance assessment process where the base questionnaire is the same; however, different departments need to phrase the question differently. Example:…
-
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…