-
Formula to reference sheet auto ticket # with survey form link so that ticket id# follows process
Hi! I was viewing How to Build a Ticket Intake Process That Actually Works - YouTube and at 9:45 minutes in, the presenter references a formula that will point to the ticket number on the intake sheet, connect it with the link to a survey, so that when the customer completes the survey and their info is input into the…
-
Removing Zero Values From Chart
I am trying to create a stacked column chart to show how many Statuses are being used per section (Section for Chart) in a project plan. However, I do not want any zero values to show. I have attempted to create a report for this chart, but I cannot get the chart to look the way that I want. What I want (minus the zero…
-
calculate networkday and exclude holiday
Hi all, I am trying to use formula to calculate the manufacturing dates between 2 dates for a factory that located a country and exclude holidays only when this country has these holidays, holiday list is in another sheet. How can I use networkday and IF formulas to achieve it? Thank you!
-
IF/COUNT and IF/SUM/CHILDREN Formula Help
I have a sheet (See below). In the 'Sheet Needed' column I have a formula: =IF(P@row = 1, COUNT([Sheet Created?]@row, IF(P@row = 0, SUM(CHILDREN())))) This is working in the Child Rows, however I am not getting a total in the Parent Rows. What am I doing wrong? I know it is late at night and I am sure I am doing something…
-
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…
-
how to keep historical sheets from triggering the formulas
Hi, We have some Smartsheet that we need to keep for historical reasons. And we backed up the sheets. How can we prevent the formulas from triggering to avoid recalculations in the historical archived Smartsheet's?
-
Form Submission - Date Help - URL string
Hello all, another form submission question. Have 2 sheets, and those sheets each have a form associated with them. On Sheet 1 Form 1 someone will place all campaign information in this form, one of them being a campaign start date. After form 1 is submitted, a link to form 2 is presented in sheet 1 that takes campaign…
-
COUNTIFS + AND Formula does not Equal the Filter Count
Good afternoon. I am having issues with the below formula equaling the filter within the sheet that we are pulling form. Please see the below and point me in the right direction to help fix this. Formula: Filter: BC/PO/BL | is one of | PO, BL, SSA, Lease, License, Other Non-Board Items Status | has none of | Awaiting CRF,…
-
Sequential Numbering Autopopulate Row
Hi all! I am trying to create a formula where every time I add a row, it aligns with the next number in the series. If it reaches a level 1 row however, the series goes to the next whole number. I wrote out manually what the numbers should be but I would like a formula to apply this automatically when i add a new row. Im…
-
Populate Column With Unique Values From Another Sheet
Hi all! I have a sheet, where tasks are entered and assigned to employees. Every task belongs to a certain company, which is specified row by row (every row is another task), this describes the first sheet we'll call "Requests". I want to create another sheet to summarize the data of every task for every company, this…
