-
Need Help with I think an IF Statement
I am trying to generate a date in one column based on an input from a drop down in another column. We have 3 complexity levels Low, Moderate, and High. Low equals 7 days from today, Moderate equals 17 days from today, and High equals 32 days from today. Below is what I have tried and it is not working. =IF((Complexity@row…
-
Counting Multi-Select Column Criteria Formula
God Day Smartsheet Community: I am Trying Count My Risk in my RAID Log. However The RAID ID is a Multi-Select Dropdown. My Formula is Returning 0 Risk when there should be at least 1 Based on the Rest of The Formula There is 1 Risk in my Source Sheet that Meets The Criteria of CPC, Open RAID Status, and Contains R in The…
-
Keep Health Status Formula When New Row Created
I am really close getting my health status formula that is based on both Status and Date to work. I need the formula to stay when a new row is added. I also want the status to be GREEN with DUE DATE = TODAY. Here is what I am trying to have happen If the DUE DATE is in the past turn the health symbol "Red" If the DUE DATE…
-
Formula on Metrics Sheet all Zeros until I open the sheet
This formula works perfectly fine but for some reason it defaults to 0 until I actually open the metrics page. I use this metric in a dashboard and everyday it changes back to 0 until I open the metrics page. Can someone explain why? =COUNTIFS({supervisorDOT}, [Primary Column]@row, {completedDOT}, 0) I even created…
-
Aggregate Red, Yellow, Green Status to One Overall Grade
Good day, I am looking to Aggregate Red/Yellow/Green status into one overall R/Y/G. Here is the criteria for grade 1: All classes are either yellow, or green, overall grade = green 3 classes at yellow, overall grade = yellow Any one class at red, overall grade = red Here is what I have tried, =IF(AND([Grade]@row = "1",…
-
date formula - how to add a time frame in the formula (2021 vs 2022)
Hi I am trying to add one more piece to my simple formula. I need to count the Released items in report for 2021, and for 2022 separately. So that we can see if the work done last year is smalle or bigger to what was done this year. So I am trying to add a date condition, preferably one that would be easily modified after…
-
IF Formula Help!
Good morning I have a formula (as below) that is relatively simple and draws from 2 different cells to return whether a machine is Online or Offline. =IF(ISBLANK([Unscheduled Downtime Reason]@row), IF(ISBLANK([Scheduled Downtime Reason]@row), "Online", [Scheduled Downtime Reason]@row), [Unscheduled Downtime Reason]@row) I…
-
Schedule Health | Average RGYB symbols
Hello community, I have created a schedule health column in my schedule and used the following formula to calculate the row health: =IF(Status@row = "On Hold", "Gray", IF(AND([% Complete]@row = 1, TODAY() >= [End Date]@row), "Green", IF(AND([% Complete]@row < 1, [End Date]@row = TODAY()), "Yellow", IF(AND([% Complete]@row…
-
Few questions in Smartsheet
-
Index Collect - Pulling from one matrix to another.
Whoops! It posted without text. LOL I've got data that's in a matrix. With Date on the left, and the Product Name in a helper row at the top. I have an entry form with this layout, and an output form with the exact layout. I need to match the Date/product to pull the value from the entry form, into a formula in the output…