-
COUNTIFS from one date through today with other criteria
Hello! Needing help creating a formula. The formula has to count all the cells in the "clearance date" column that are blank with the criteria from the "application effective date" which is all dates happening 10.1.2021 through today (which means counting on a rolling basis) I have this formula below that isn't working:…
-
Formula for 2 criteria
Hi, I'm trying to come up with a formula to count all the students in grades K, 1, 2, 3, 4, 5 who are also in our life skills program. I have the formulas separate =COUNTIFS(Grade:Grade, ="K") + COUNTIF(Grade:Grade, <6) =COUNTIF([Life Skills]:[Life Skills], 1) I tried =COUNTIFS(Grade:Grade, ="K") + COUNTIF(Grade:Grade, <6)…
-
What's wrong with this formula?
=IF(Due date,<=Date closed, "yes", "[No]") the intent is to record yes or no in a helper column dependent. The former if the date closed is on or before the due date. The latter if after the due date. Thanks in advance
-
Issue with Date column with formula =today()
Hey Smartsheet community Has anyone encountered this issue where the Date field with the formula = today() is not updating on its own until and unless you open up that sheet? I have a sheet which powers my Dashboard and I need to open up this sheet so that the date column reflects todays date and hit save, else it will be…
-
IF with INDEX MATCH
Hello, I would like to check a box on one sheet, if a box is checked on a different sheet, matching certain criteria. This is what I have so far: =IF(INDEX({Current Estimates Range 1}, MATCH([Project Name]@row, {Current Estimates Range 2})) = 1, 1) If the Takeoff Information Column is checked on this sheet, then check the…
-
Creating horizontal view for existing sheet
Hi, I'm trying to get sheet A (vertical view) into sheet B view (horizontal view). Sheet A: Sheet B: the helper column date is in txt/number so it would match sheet A. Could anyone help? Thanks. :)
-
Formula for Finding ISBN Numbers
I wanted to share a Formula / Method for validating ISBN numbers since I didn't see any discussions or suggestions on how to go about, I thought I would make a post here for if anybody wanted it or had discussion ideas on it. I was recently tasked with creating a book request form where users would need to submit ISBN…
-
Return a value using Index/Match having multiple matching criteria
Hello Smartsheet Community, Does anyone know if we are able to return a value using the Index/Match but match two criteria? I have one sheet that is searching in the other sheet for two values in two different columns and will return a value in the third column. It will only return the value if the other two values match.…
-
Formula and Color Change in Cell
Hello, I am wondering if it was possible for the "Initial Risk Score" cell color to change when the "Probability" and "Severity" is selected? I currently have the following formula in all cells "Initial Risk Score" =IF(AND(Probability1 = "Improbable", Severity1 = "Negligible"), "1", IF(AND(Probability1 = "Improbable",…
-
Can I use 2 formulas in 1 cell/column?
Hello! I'm stuck trying to put to formulas into one column. Here's the scenario. I have multiple projects with multiple subtasks. When the Status column is updated to "Completed" I would like the Progress column to update to 100%. I've successfully completed this step with the formula: =IF(Status1 = "Completed", "100%") in…
