-
Joining cells of multiple columns into one cell
I would like to gather the row responses in the columns outlined in red into the column outlined in green so that I can display just one column in a report instead of several. I have the following format I am starting from. It works well for rows with only one response to gather. It doesn't work for instances where there…
-
Why sometimes a formula works and other times it shows #CIRCULAR REFERENCE?
I am working with this formula IF(ISBLANK([MoH ID]@row) = true, "", IFERROR(VLOOKUP([Val ID MoH]@row, {2.1 MoH Range 1}, 16, 0), "Error ID Trámite")). It worked for a few weeks and then suddenly when I open the sheet the formula result is #CIRCULAR REFERENCE. After few days, I opened the same sheet and the formula shows…
-
If function
Hello, may I request assistance troubleshooting a formula? I have the formula below to identify if the reconciliation is out of balance. In January, the Available Resources and Fiscal Report Ending Balance match, yet the Status display Out of Balance. Is it because it's a negative number? =IF([Available Resources]@row =…
-
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"…