-
Formula for impact score x likelihood
Hi i currently have the below formula but need help amending this =IF([Impact Score]@row = "", "", [Impact Score]@row * [Likelihood Score]@row I need to amend this for if column type is risk then impact score* likelihood score and if column type is issue then return impact score only Thanks
-
IF OR formula for 3 conditions
Team, Struggling to get the below formula to work…any thoughts. (The cells contain numbers in text/numbers columns): =IF(OR([02/01/25]@row < [01/01/25]@row , [02/01/25]@row <> [01/01/25]@row , [02/01/25]@row > [01/01/25]@row ), "Down", "Same", "Up") Thanks
-
Multiple if statements with And and Ors
I have multiple Ifs and I seem to have tied myself in a knot. =IF(NOT(ISDATE([Earliest Day 180]@row )), "Red"), IF(AND([Send HIE]@row = "Green", ePrescribe@row = "Green", [Receive & Reconcile]@row = "Green", [Provide Patient Access]@row = "Green"), OR(PHCDE@row <> "Green", [Query PDMP]@row <> "Green"), "Blue"),…
-
IF Statements with Dates
Hi all, I am clearly missing something… I have a sheet with columns for the Start and Date Ends and then another column to track the Status (In Progress, Enrolled/Upcoming, Completed). The formula is currently: =IF([Start Date]@row > TODAY(), "Enrolled", IF([Start Date]@row < TODAY(), "In Progress", IF([End Date]@row <…
-
Multiple Condition Duplicate Line
Hello, I am creating a tracking system for PO's that need to be entered into a system. The problem is that a PO can be split into multiple truckloads and delivered to the facility on mutliple dates. The facility enters each PO that is needed based on a schedule but if the PO had been received previously, they do not want…
-
How to add another calculation to an If statement and Index/Match
Hi, Hopefully this will be an easy one. My brain is going completely blank on this. I have a formula that is basically calculating/selecting one of three values based on which is not empty. It is based on the user checking the "Included" box to trigger an index/match formula to show the cost (Hourly, ,Unit or Fixed), and…
-
Using If/or/and to change date based on different drop downs and checkmark selections
Hi all, Adding on to an existing formula to automatically add a number of days depending if a column is checked or not. The bone column is either "NA" or various types of bones which populates the final date in the QC column based what is selected. I'm trying to add if the Timeline extension box is checked, it will add the…
-
How to use "OR" when having several IF statements
Hi, I posted a question earlier today so this is similar but maybe a different way of going about the solution I'm looking for. I am trying to figure out how to use "OR" when having 3+ actions in a single formula based on if a field is blank or not. My scenario is this: ORG Code 1 Object Code 1a Object Code 1b Object Code…
-
Help with multiple IF ISBLANK statements
Hi, I am trying to list values, comma delimited, from a number of columns based on if the previous column is blank. So for example, based on this table: Object Code 1a Object Code 1b Object Code 1c Object Code 1d Object Code 2a Object Code 2b Object Code 2c Object Code 2d Object Code 3a Object Code 3b Object Code 3c Object…
-
IF Formula
Hi I would like help on a formula to score time criticality. Ive tried the below but its coming up with errors. I also would like to add a formula that if there are any negative numbers such as -201 then this would show as "10" Formula i used below but not working =IF([Time Criticality]@row <= 30, "10", IF([Time…
-
Return a date or month
Hello! Is it possible to write a formula to get the following result - Start Date Column: if it's a confirmed date, a date two weeks earlier in a photography due date column is calculated (this works by using this formula: (=[START DATE]@row - 14)) HOWEVER, if a start date is TBD and I put in the Start Date Column "March…
-
How do I use multiple IF statements with multiple criteria?
I am new and trying to write an IF statement with multiple criteria. The sheet will accept my formula, it will only deliver the result in the cell for the 1st two statements. I read a ton of remarks from others in the community, and I just can't find where I'm making the mistake. Any help at all would be much appreciated.…
-
How do I create multiple IF statements in a function
Here is my current formula for the column "Tech Setup Price" =IF(AND([Tech/Set Up]@row = "yes", [Is the frame curved? ]@row = "Yes"), 650, IF(AND([Tech/Set Up]@row = "yes", [Is the frame curved? ]@row = "No"), 500, 0)) This does not include the below added variable of the Neo Modular System, so I want to add that variable.…
-
If Or Statement
Hi All - I've been going round and round with this formula and getting the Unparseable error. My guess is that it is really simple, but I'm not finding it. I want invoices that are current, paid or less than 30 days old to return green. I want invoices over 60 days old to return red. Anything else to return yellow. My…
-
Need a space saving IF OR formula
I have a working function to assign a school county to a new entry when a certain institution ID is put into the column. My issue, however, is the complete equation to accomplish this is too long and doesn't fit the last few school districts. I'm checking to see if there is a more elegant way to accomplish this so I can…
-
Column Formula Help - Helper Checkbox for Shift Entries
Hello Community, I am looking for some help with a helper column checkbox formula needed to support reporting of data to a dashboard and downstream formulas. I have four shifts (A,B,C,D) entering data points into a sheet, with the potential for multiple line entries occurring per shift per day worked (see example below). I…
-
Nested(?) If statements
Not sure if nested is the right term. I want the formula to show - If any of these columns (IT, SUS, HSE etc) have "Not Achieved" in them then look for the largest/ latest date from the columns IT comp. SUS Comp. HSE Comp. and display that date. Otherwise "Badges complete". The result column is a date column so not sure if…
-
Multiple Sequences Need to Be Complete/NA to Provide a Complete Value
Writing formulas is not a strong suite of mine - I've tried a few routes (IF OR AND) but I'm either running into invalid formulas or formulas that are not netting the right results. I am trying to write a formula where I'm looking for sequence values to be either Complete or N/A and based on those sequences being one of…
-
Using IF OR MATCH to Check for Value in Multiple Sheets
Hi, I am trying to write a formula that will take a value from the sheet the formula is in and check for that value in other sheets. If the value is found in at least one other sheet, the formula should return "Y". If it is not found, it should return "N". This is my current attempt, but this just returns "N" for…
-
I believe I need help with an IF OR formula
I am trying to create a formula where my swimlane shows as complete if the completion is complete, but if a project is in progress but the status is still green, I want it to show as On Target. How do I make my formula so that green is On Target unless it is marked as complete, in that case it would be called complete.…