-
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.
-
Error while transfering a formula from Excel to Smartsheet
Hi! Someone tried to transfer a formula from excel to smartsheet... The only problem is that the formula is quite long and there is one/multiple error(s) left. Can someone help? I've found a few ones ( ; instead of , ... WEEKNUM instead of WEEKNUMBER) but I can't get it to work... Here it is. I colored the different if…
-
Release 2016-08-06 INDEX function?
When was the INDEX function released? Was it this one? I can find no reference to it in the release notes (searching the whole page), the last version of the Formula Examples does not mention it nor does the blog entry for this release. It is mentioned here: http://help.smartsheet.com/articles/775363-using-formulas but…
-
=COUNTIF above a row
Hello, I'm wondering if there is a way to set the range in a =COUNTIF function to only count above a specified row. We currently use a form to generate actionable rows the the top of the smartsheet. As items are completed we move the actionable row to a collapsable archive parent row. I want to set up a function to…
-
Formula to copy contents from one cell to another?
Hi there, is there a formula that can copy/mirror the contents of one cell into another? We need this for Update Request purposes - we have two types or requests we need to send to a business partner, both with some overlapping and unique column needs. For example: Update Request type 1 - fields to check off: · comments ·…
