-
Autonumbering does not always work?
Hi there I have an order reference column set to auto number. It is prefixed by the date and then an autonumber for the order on that day. For one user the autonumber does not always seem to work, if he creates a new line it uses the same number as the line above. This means we end up with two identical order numbers. For…
-
Formula to count/sum grandchildren
Is there a formula that can be used to count or sum the grandchildren of a parent row? For Instance: * Parent Row: United States * Child Row: East * Grandchild: Florida * Grandchild: Georgia * Child Row: West * Grandchild: California * Grandchild: Oregon * Child Row: Central * Grandchild: Illinois * Grandchild: Texas *…
-
Release 2016-08-06 Formulas template link is wrong
Regardless of how I get there, the template for formulas is wrong. https://www.smartsheet.com/solutions/smartsheet-formula-examples is version 1.5e I have 1.6 from July 2015 Craig
-
Formula using both an IF and SUM(CHILDREN()) parts
Hello people I would like the cell in [Total]5 to show the sum of all its children, but only if the [Qty of Tasks]5 cell is empty. If [Qty of Tasks]5 is not empty, then I would like [Total]5 to show =SUM(Tender5 + Variation5) I have tried =IF([Qty of Tasks]5, "", =SUM(CHILDREN()), (Tender5 + Variation5) * [Qty of Tasks]5)…
-
Use linked cells as part of a formula
I'm trying to port across a large database from Excel into Smartsheet to enable us to use the Kanban type activity flow. My excel sheet uses multiple tabs, and on one of these tabs I have an 'Analysis' section that pulls in data from all of these tabs and uses cell references from multiple tabs. Smartsheet (not using tabs)…
-
Function 'WORKDAY' returning #INVALID COLUMN VALUE when formula in different column
Hi, I seem to be having difficulty with something that should be so simple. I have two columns 'Date Required' and 'Decision Date'. 'Date Required' is a user input date field, 'Decision Required' is (or should be), an auto-calculated field to subtract 5 working days from the 'Date Required' field. The formula I have…
-
Date-based formulas now broken across 100+ sheets
As a result of the latest release and supposed "formula enhancements", we now have more than 100 client-facing project sheets whose "status" column is entirely broken. Previously our status column looked at the task Start Date, End Date, and Target Date, and intelligently spit out a text value such as Due Soon, In…
-
How to autopopulate a column with formulas such that when a new line is inserted, it is automaticall
How to autopopulate a column with formulas such that when a new line is inserted, it is automatically filled in and calcuated?
-
Release 2016-08-06 Formula Argument Declaration confusion
The release notes says: Formula Argument Declaration Calculations can now run faster with the new logic for identifying a range. Rather than using =if(a1:a3) to specify a range in your formula, your functions will need to identify each cell, =if(a1, a2, a3), separately to be able to run the argument. Using the IF()…
-
Release 2016-08-06 MATCH function
The MATCH function accepts multi-dimensional ranges. I believe that EXCEL does not, but can not confirm. This example returns "9". If the range is three columns, match returns 7. Is there some intended usage of a 2-dimensional search that would be useful? I see the array is processed as row major. Knowing the size of the…
