-
INDEX/MATCH function doesn't return exact match.
I'm having and issue with the MATCH function not returning an exact match. If my understanding of the formula is correct: "1" for the [search_type] should find the first value greater than or equal to the search_value starting from left to right, or top to bottom. "-1" should find the first value less than or equal to the…
-
Nested and/or formula
I am trying to set an at risk flag when a date is in the past and the status is not cancelled or complete. I have used the following formula in Excel and it works, however, I cannot make it work in Smartsheet. Any advice? =IF(AND([Due Date]@row < TODAY(), OR(Status@row="Cancelled", Status@row="Complete")), 0, 1)) I did get…
-
Is there a way to count the number of dates in a cell?
I want to include a column that indicates the number of times the due date has been extended, but not sure what would be the best way to do this. The "Fulfillment Due Date History" Column on my sheet has a cross-sheet formula that lists the various due dates if they have changed. Could a formula be set up to count the…
-
I'm Trying to flag if a colum says RISK but it comes up as #UMPARSEABLE
Help please =if(Status@row=RISK, 1,0) Is not working
-
COUNTIFS in Sheet Summary Formula
Hello, I am trying to create a Sheet Summary variable that captures milestones completed last quarter. I have the following formula in the summary sheet field: =COUNTIFS(Status:Status, "Complete", Start:Finish, AND(@cell >= IFERROR(DATE(YEAR(TODAY()), MONTH(TODAY()) - 4, 1), DATE(YEAR(TODAY()) - 1, MONTH(TODAY()) + 8, 1)),…
-
Looking for help with "Contains"
I am looking for some help with the Contains function. I currently have the following formula which is working fine. =COUNTIFS({2021 Archive Range - RFI Reason}, "Census", {2021 Archive Range Assigned To}, "JP Pedicino") I need to update it to search for CONTAINS "Census" in the 2021 Archive Range - RFI Reason range and…
-
#INCORRECT ARGUMENT SET (not sure what I did with this formula)
The current formula in the Tenure Category is below and returning #INCORRECT ARGUMENT SET so I'm sure something is off but not sure what it is.
-
Formula help: Same criteria, same date, multiple rows
I feel like I'm missing something obvious here, but I'm struggling to come up with the correct formula to accomplish a task. Multiple attempts have come up empty. What I'd like to do is: When there are more than one instance of the Distribution column displaying 4 stars on the same day, I'd like the checkbox in the Status…
-
Red/Yellow/Green
I'm attempting to use red/yellow/green logical function to highlight when a % is Meeting (green), Nearing (yellow), Missing (red) a goal. The Green and Red are easy...the yellow is tough! This is what I'm trying...but not working: =IF([Q1: 7.1.21 to 9.30.21 %]@row >= [Performance Target]@row, "Green", IF(AND([Q1: 7.1.21 to…
-
POWER function from Excel
I am migrating a CVSS calculator I found online into Smartsheet, and it seems that if I can find a way to replace the POWER function from EXCEL, the rest of the formulas will fall in line. I need a solution to this formula : =IF($Scope1="Unchanged (U)", $[R_S]1 * $[I_Mul]1, $[R_S]1 * ($[I_Mul]1 - 0.029) - 3.25 * ($[I_Mul]1…