-
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…
-
New Hierarchy Function - ANCESTORS()
http://help.smartsheet.com/articles/775363-using-formulas I got super excieted when I saw the new Hierarchy functions, ANCESTORS() & PARENT(). I get PARENT(), know where I plan to use it and am happy to have it. After testing out ANCESTORS() and reading the blog, I realize that it's primary intention is for forconditional…
-
Disable Rollover Formula Preview
Hello, Is there anyway to disable the feature that previews the formula when you roll over a selected cell? My sheets often have very long formulas in the Primary Column and the rollover gets in the way of being able to read the sheet effectively.