-
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.
-
Calculating the task completion
I know this must be simple but unfortunately so am I I am managing a project and I have set it up with a fairly standard heirarchy of task (parent) and sub tasks (child). The sub tasks have a number of individual work items associated with them and I want to use the number of individual work items completed to…
-
Formula help...can this be done?
Column A is a date column. Column B tells us if we have scheduled Column A so it will sort into the right report. The formula in Column B needs to state that if Column A is a date, then the value is YES; If Column A says "Not Scheduled" it is No. Otherwise, Column B will remain blank. Can that be done? Blessings, Loann
-
RYG balls based on task completed
I have a sheet where I want to update the next columm based on the RYG color of the first. For example: If Column 1 = Green then I want Column 2 = Blue I think I am close on the formula but it just isn't playing nice. Thanks!
-
RYG balls based on dates of activities completed
I have been following some threads discussing how to use RYG balls in conditional formulae based on a date column (i.e. green if the date is in the future, yellow if it is today, red if in the past, etc.), and those are very helpful! I would like to do the following, however, and I cannot find a thread that addresses this…
