-
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 ·…
-
hide formula errors
Hello, I have WORKDAY formulas that are correct, but there is insufficient data to return a value in the formula cell so I'm getting an error. (There's no due date yet) What I would like is a way to simply hide those errors, but still have values appear when due dates are entered entered into the cells they reference to…
-
How can I write a formula to summarize in parent row summaries in child rows?
Column is entitled Status and is a drop down list with the following selections: Not Started In Progress Delayed Cancelled Complete I have a formula in each child row to summarize grandparent rows: ="Not Started (" + COUNTIF(CHILDREN(), "Not Started") + "), In Progress (" + COUNTIF(CHILDREN(), "In Progress") + "), Delayed…
-
Conditional Symbols $ to $$$$$
Hi All, I went looking for the below but did not find it, so i built it. Use the below for a 1-5 symbol column like ($-$$$$$) to conditionally set the value based on a column in your list. =IF(Saving1 = MIN(Saving:Saving), "One", IF(Saving1 = MAX(Saving:Saving), "Five", IF(Saving1 = AVG(Saving:Saving), "Three", IF(Saving1…
-
Changing sign of a Sumif or Sumifs result
Is there a "proper" way to change the sign for SUMIF or SUMIFS formula results. I have found that =-SUMIF() doesn't work; but, that = 0 - SUMIF() does. Is there a way to do it without the "0"?
