-
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"?
-
The Time it Took to Perform a Particular Action
Hi, I realize the questions is quite vague, but is there any way to show/calculate (this need not necessarily be done via a Report as the word is used in Smartsheet terminology) the time it took for somebody to complete a certain action. I,e. let's say there's a task that somebody is assigned to and they begin this task by…
-
Mathemathical Operations on Dates/Date Columns
Hi, is it possible to perform mathemathical operations on dates/date columns in Smartsheet. Specifically, can I "deduct" one date from another or somehow calculate the difference (in days) between the two? Thank you.