-
Allow single cell references to be converting to column formulas
Currently when you want to reference a single cell in another row you cannot convert the cell formula to a column formula without getting a syntax error even though the formula works fine as a cell formula. I need this functionality as I am trying to figure out a work around to do round robin auto assignments for new items…
-
Cross Sheet Formula Help - SUMIF, SUMIFS, OR - Which to use?
I'm trying to create a cross sheet formula that will track the dollars spent on items in various stages. I've easily created formulas for two separate stages, "Pending" and "Requisitioned". I'm struggling now to create a cross sheet formula that encompasses everything past "Purchased". This includes "Received", "In…
-
Reference Sheet Summary fields in formula in sheet
I need to create a formula that concatenates (JOIN or "+") several fields in my sheet summary, back into a column in my sheet. What is the syntax I need to use to be able to reference sheet summary fields? Thanks!
-
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…
