Trending in Formulas and Functions
-
Can you help me with a COUNTIFS Formula (Second Criteria)
Trying to count Rows in a sheet that meet 2 criteria. I am not an advanced user, so I am missing something. Can you take a look at this formula and give me some suggestions? =COUNTIFS({Phase-TPN}, "1", [Start SCRA]:[Start SCRA], "Yes")
-
Can you convert this vlookup to an index match or index collect?
basically, it rest id exists in both SS and on the other SS a field is either checked or unchecked, then result should read Yes. =IFERROR(IF(AND(VLOOKUP([Restaurant ID]@row, {CFA NRO/Remodel Cabling Tracking Range 1}, 1, false) <> 0, VLOOKUP([Restaurant ID]@row, {CFA NRO/Remodel Cabling Tracking Range 1}, 39, false), 0),…
-
Help with Health Formula
When I put this formula: =IF([% Complete]@row = "100%", "Green", IF(AND([% Complete]@row <> "100%", [Due Date]@row >= TODAY()), "Yellow", IF(AND([% Complete]@row <> "100%", [Due Date]@row < TODAY()), "Red", ""))) The status shows Red when the % complete is 100% and the Due date is past. How can I correct that? Thanks
