-
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'.
-
Archiving Design Pattern in Smartsheet
Hello, We currently have a very large Smartsheet we use to collaborate with external business partners. I have created workflows to add rows each week, and our cross-functional teams complete tasks related to each of these rows over a period of weeks. We are struggling to find the best way to declutter this sheet once all…
-
Formula to show text next to sum amount
Good day, Our Currency ( BHD for Bahrain Kingdom ) is not one of listed currencies and I wish to show it to amount numbers , how to have Currency BHD seen next tp total sum in below formula ? =SUM([Service Charge]4:[Service Charge]13) Also , is there a way or formula to show text ( BHD ) or any other text next to number…