-
IF, AND, OR Formula
Hello, I am trying to write a formula to use the flag symbol to flag a row as urgent IF the location is "Real" AND Staffing Status symbol is "Yellow" OR "Red". I am having a hard time combining them all to have the correct syntax. This is what I have so far: =IF([Location Status]@row = "Real", AND([Staffing Status]@row =…
-
SumIF from another sheet
Hi, I have a formula that sums up the expenses for a particular billing code, like this: =SUMIF([Account Code]:[Account Code], "539023", [Expenses Submitted]:[Expenses Submitted]) This works well, however, I want to use this code on a different sheet, without having to link to a bunch of cells on the first sheet. I can't…
-
Help with a Formula for Status Change
I want to create a formula that changes the status colors to red, yellow or green. Below are the criteria: IF Due Date is < Today and progress bar is not "Full", then "Red". IF Due Date is > Today - 3days, and progress bar is not "Three Quarters", then "Yellow" All other scenarios = "Green" Any help or suggestions would be…
-
VLOOKUP matching text, referencing another sheet
I am trying to match a vendor name between two sheets and if it is found to display a risk rating from the other sheet. I am getting the error message #UNPARSEABLE with the formula below. What am I doing wrong? =VLOOKUP("[Vendor Name]@row",{Vendor Risk Rating Summary Range 1,{Vendor Risk Rating Summary Range 2},false})…
-
IF AND formulas
I can't get the following formula to work, getting the #UNPARSEABLE error: =IF([Regulatory Impact Score]@row >= 3.75, "High"), =IF(AND([Regulatory Impact Score]@row < 3.75, [Regulatory Impact Score]@row > 2), "Moderate"), =IF([Regulatory Impact Score]@row < 2, "Low") If I separate these into three different formulas, they…
-
Sheet Summary COUNTIFS using netdays
I am trying to count how many requests are open for more then 2 days in sheet summary. The above formula results in #UNPARSEABLE
-
Embedded IF(AND(OR Function Help
Hello, I have three columns in my sheet each with dropdowns including a "Complete" - type answer and a "Not Required". In the fourth column, I am trying to write a formula to show when the row is 'good to go' - such that all three columns read either "Complete" or "Not required". I've tried to do this by embedding an "OR"…
-
Need help in AverageIf formula with 2 condition
Hi team, I need help with an AverageIF formula. I am working on the request tracking system for Import shipment. I would like to calculate the average days in transit with 2 conditions, 1. Country (USA, UK, Sweden, etc), 2. Mode of transit (Air mode, Ocean Mode, Courier mode) + Average days in transit. Existing AverageIF…
-
SumIF HAS with cell linking
Hi All, I have been struggling to find a solution on how to get a Sumif formula to work. Essentially, I want to Sum if a cell contains a specific name, however the name column is multiselect and can have multiple people in it. I have tried both the HAS and CONTAINS formulas but haven't been able to get one to work. The…
-
Calculating percentage based on status options across multiple columns
I am trying to average the sum across multiple columns. Each column is a single select dropdown that will allow the user to choose from the following options: ⦸ (Not applicable) ◷ (in progress) ✓ (Complete) I want to assign values to these symbols. ⦸ = 1 ◷ = 0.5 ✓ = 1 I have only been able to get the following formula to…