-
Averages with Errors
Hello, I'm trying to take an average of a range of cells. Some of these cells have a #Divide By Zero error in them because the source sheet does not yet have applicable data. I have used an IFERROR statement to change these cells into "blank" cells, yet when I use the following formula: =AVERAGE([Avg. Functionality]1:[Avg.…
-
Text in Date Column Messing Up Formula
I have 8 date columns where sometimes I enter text. Either the date of a document's expiration, or if the document was simply "received." I have another helper column that I want to be checked off if any of the 8 dates are expired. BUT I'm finding if I have text in any one of them, the formula becomes "invalid operation."…
-
RGY Status - Overall Roll up
Hello helpful Smartsheet-ers! I have several rows that are utilizing the RGY buttons for health. I am trying to roll these up to a general status based on the choices in the individual rows. Can anyone help with a single formula that would capture: Green if all elements (rows) are green Yellow if one or more elements are…
-
CHILDREN() and INDEX() Killing Me!
Hello- I need to pull the value from the 1st child row, 3rd column. If that value is == to "Hold", then the cell should return a value of "Hold". I'm trying to follow the help guide as well as some community posts, but I'm not getting it. What is the proper syntax? The goal is to have the parent row's "Current Status" cell…
-
Lookup text or number in last cell
Hello, I know how to do it on Excel, but cant seem to get it to work on Smartsheet. I have sheet that gets updated by a form filled out by other people. I would like a formula that would get the last piece of information added to particular cells in this sheet (add to bottom row) and display this in an overview cell.…
-
Referencing a Column in Another Sheet
I am having trouble referencing a Column in another sheet through an IF formula I am trying to do. My current formulas is =IF({Sheet 1 Range 1} = 1, {Sheet 2 Range 2}). The first Column I am referencing is a Checkbox Column, and I only want it to return the value in Range 2 unless Range 1 is Checked. Whenever I do this…
-
Formula Help
Hi, Need help combining these two formulas to calculate the # of days open from the date of entry. Not to include "Solution complete" or "Solution identified and agreed upon". =IF(NOT(Status@row = "Solution Complete"), (TODAY() - Date@row), "") =IF(NOT(Status@row = "Solution identified and agreed upon"), (TODAY() -…
-
COUNTIFS multiple criterion
Hi All, Maybe somebody could help me to figure how does COUNTIFS formula works? I am trying to get summed cells which has specific naming from the drop down. I want to count "Dismounting" cells only if Column "Done" is not checked. At the moment I am typing formula in this way: =COUNTIFS({Type}; "Dismounting"; {Done}; "0")…
-
Recurring Weekly Tasks Formula
I have a sheet set up with a weekly task, a column for last completed date, and a column for next due date. I have a column that indicates the day of week that it must be completed on. I am trying to set up a formula in the next due date column that uses the selected day of week to update the next due date based on the…
-
SUM 2 COUNTIFS functions #INCORRECT ARGUMENT error
I am trying to sum 2 countifs functions and I am unsure why I am getting an error. I was hoping someone could help me fix this error. =SUM((COUNTIFS({Jade3_BCM Dashboard 2019 Range 1}, "Examine & Validate", {Jade3_BCM Dashboard 2019 Range 4}, "Execute on Timelines", {Jade3_BCM Dashboard 2019 Range 3}, "1st Quarter")),…
