-
Yet another RANKEQ question! :)
Hello all! I've been diving into Smartsheets, and more recently Dashboards since taking on my new role in Quality Assurance and have come to a roadblock. Goal: I'm attempting to pull a "Top 5 error offenders for yesterday" to display on my Quality Dashboard so it updates automatically. I have a column ("Errors Yesterday")…
-
CountIfs
I am trying to work with a countifs formula. I have a column titled "Event Date" Format MM/DD/YY and a column titled "Risk Level". Values in risk level are "low", "medium", "high". I am trying to count the number of each risk level that occur each month/year. I can get the count for each risk level ok, but adding the date…
-
Update project status column based on the information in multiple columns, using IF, AND, ISERROR
I have a formula using IF, AND, ISERROR, and COUNT in excel (see below), which works. =IF(AND(ISERROR(FIND("Cancelled",AE2&AP2&AY2&BG2,1)),ISERROR(FIND("On-Hold",AE2&AP2&AY2&BG2,1)),K2<>"NSG"),"Stage "&COUNTA(AE2,AP2,AY2,BG2)+1,"n/a") I'm trying to update the formula to work in smartsheet, and have updated to this point,…
-
IF formula with date range that defines a set time period
Statement to solve for - If FINISH date is between x and y dates, the it = 30-60 (time period in a drop down) Formula created, but not working =IF(Finish)42 >=DATE(2020, 12, 21) OR <=DATE(2020, 12, 25), "30-60") Can anyone help solve for this so that I can automated setting a time period based on the task date?
-
Adding another requirement for Countifs formula
I know this should be easy but I cannot get a good return. The current formula I use is as follows: =COUNTIFS({Initial Date - POR}, IFERROR(YEAR(@cell), 0) = 2020, {ROT - POR}, 1) Works fine except I want to add another criteria from the same sheet: (Status, "Closed") And since this is a sheet with multiple years, it just…
-
Count Progress Within a Specific Parent Section
Hello, I am new to Smartsheet so I may not be using the correct terminology. I am trying to count the number of tasks set to a certain "Progress" within my project sheet. Ideally, I would like to break up this count by the different parent sections we have set up (Government Officials, Healthcare & Medical Offices,…
-
Return a number count based on criteria within two separate columns
I'm seeking a formula that will return a value if a certain criteria is met in one column and another criteria in another column. For example, I'm trying to count how many items there are that have "Medium (within next FY to 3 yrs)" with a status of "Green". I'm trying to report this in Sheet Summary. Thank you!
-
Help With Formula
Hi - I need to add 2 dates to come up with a total of how many days passed. Example: Column A - 1/1/21 + Column B - 1/15/21 = 15 days Thanks!
-
IF statement that sets a drop down symbol
Looking to utilize Harvey balls so when a % Complete is within a range (see below) it defines the proper Harvey ball. I am able to accomplish the formula using 2 variables but unclear how to set for a range? FORMULA =IF([% Complete]1 >= 0.9, "Green", IF([% Complete]1 <= 0.8, "Red") Example Ranges for Harvey Ball. G 90-100…
-
Can you use an If...Then Formula to populate multiple columns?
Hi! I am looking to create a formula that will auto populate three columns depending on what region is chosen. For Example: If the region chosen is the Northeast then I want Person 1, 2 & 3 to auto populate. If the region chosen is the Mid-Atlantic then I want Person 1, 4 & 5 to populate...and so on. Is this possible? I…
