-
VLOOKUP equivalent -- #NO MATCH error
Hello! I have a formula I'm using across several sheets referring to a source table. On 9/10 sheets, the formula works just fine. However, on one the exact same formula yields a #NO MATCH error. I've double-checked my references and everything looks good -- e.g., the match criteria does indeed exist where it should. Any…
-
Average children with IF
hi, i have sheet with ~300 parent row and ~1200 children row. i try to sum the progress in parent row with IF on his children. for example : if one of the children row is "sent to fabrication" he get 100% and i have five children row i want to see in parent row the value 20% progress. (1+0+0+0+0)/5
-
I have a column that is Closure Rate % -- and want to indicate trending
I have a column called Closure Rate - which is a % formatted field. I want the insert a column to the right that indicates if the value in Closure Rate = <25% then show up arrow, if not show down arrow. is this possible? I have the column properties set correctly. =if([Column12]3<25%,1,0)
-
IF AND formula with between dates
I'm trying to toggle and RYGG status field with a formula. The idea If the contract send day is more then 14 days ago and the contract hasn't been executed I want the status to be RED. If the contract day is more than 7 days, less than 13, and the contract hasn't been executed the status should be YELLOW. Otherwise it…
-
#Blocked when using SUMIFS formula on sheet summary
I am getting a #BLOCKED error message when trying to use a formula. I copied a formula that worked and changed the column name, which then gave me the error message. Not sure what is wrong or how to fix it. =SUMIFS([COBID # of Consultants by Project]:[COBID # of Consultants by Project], Level:Level, =1) - this is the…
-
Is there a way to Count items that are Closed Today?
I have work queue and status column. I would like to count the number of items that are closed (daily) or today. I understand this number would change throughout the day. Can someone assist? Thanks!
-
Round Whole Dollars Up to Five Dollars
I have a column that takes a rate and decreases it by a discount percent: =[List Rate]@row * (1 - ([Client Discount]@row + [Selected Discount]@row)) For Example $ 300 less 15% discount = $ 255 $ 250 less 15% discount = $ 212.50 $ 90 less 15% discount = $ 76.50 I want to apply calculation that will result in rounding up to…
-
"IF" function question - Urgent if possible
I have a sheet where i am tracking multiple different tasks for completion. i am attempting to create an (Overall status) once a few key items are marked completed, and or box is checked. Can someone explain how this can be done? Example: EDI setup-completed, testing successful check box checked, contracted check box…
-
Multiple IF/AND Statements
Hoping someone can assist me with a formula. I've spent quite a bit of time trying to figure it out on my own and can't seem to get it. I have multiple criteria to determine the value of a field. The field values would be Ops, G1, NG2, G2, and Full depending on various criteria. Here is the logical expression: If [Tshirt]=…
-
How do i write the following formula
I am trying to write a If-nested formulas that works out the following. What i am trying to say with this formula is the following: IF the status is Complete and the planned end date is today or within five working days = Green IF the status is In Progress and the planned end date is today or with in three working days =…