-
Max Cost per Year
I need to determine the max Remediation Cost PER Year. I also, need to pull this information into another sheet's cell. What's the best way to go about this? This is the formula I have thus far, but it's coming out UNPARSEABLE... =MAX(IF([Date of Incident]:[Date of Incident], <=DATE(2020, 12, 31), [Date of Incident]:[Date…
-
Collect Function with Multiple Criteria
I have the following collect function that works fine when I only have one criterion (the answer is 6) but, when I add the additional criterion to evaluate the Date I get an answer of 1 instead of the 6 I was expecting. Any help would be appreciated.
-
How to calculate elapsed time between status changes ?
Hello, Is there a way to calculate the elapsed time between two status changes ? I would need to know how much time it took for the status to change from yellow or red to green. Ideally, I would like to be able to calculate a mean per territory, department and my whole plant on time between yellow/red to green status…
-
Sheet Summary - Countif - #Invalid Operation
Hi all, Ok I am going crazy, hope someone can tell me where I am going wrong: I keep getting #Invalid Operation on a sheet summary Countif Formual based column "Days to Obtain PO Range" - This column had a formula in it I have a second column called "Test" - this column has the same formula as the above Why am I getting a…
-
Value of a cell is changed if a reminder is set on a row
Good Morning, I have the need to report on a master sheet when a reminder is set on another sheet. I want to be able to modify the value of a cell if a reminder is set and then I can link up that value into the master sheet. Thanks Juan
-
Looking to turn Predecessors cell into a comma delimited list without "FF", "FS", "+x d " etc.
Hello, Looking for some help from skilled smartsheet formula writers on how to copy the contents of a predecessor cell into another cell but without leads, lags, "FF, FS, SF etc.". TO give you the full picture of what I am trying to achieve: My ultimate goal is to be able to identify a list of successors for a given row. I…
-
Created Date, error when referenced in formula
{Date Submitted} is a cross-sheet reference to a column of Created (Date). {Total Findings} is a cross-sheet reference to a column of numbers generated via a formula. [Week Number]@row is a primary column with numbers in it. Formula 1 below works fine. However, formula 2 returns a #INVALID DATA TYPE. How is this possible?…
-
Flag or Conditional Formatting?
I want a way to 'flag' a cell if it is out of range of two other cell dates. I haven't been able how to do that with conditional formatting because I can't set a condition to say if "this column" is NOT between "this column" and "this column" (where the dates change for each row). Is there a way to do that? I thought I had…
-
Creating a Formula for Dates and Traffic Lights
Hi, all! Our office is new to the SmartSheet community. I am having some trouble creating a formula for a sheet. I have the following columns: * "Initial Contact" - formatted as a date * "30 Days Since Contact" - formatted as a green traffic light * "60 Days Since Contact" - formatted as a yellow traffic light * "90 Days…
-
Formula to change line item to 'at risk' when due date is passed
Goal: When a finish date is passed on a line item, I want the status column to change to 'at risk'.