-
I'm Stumped - Need a Percent Average when applicable
I have tried a number of ways to get this to work, and my hunch is I'm needing a percent average from other percent averages (where some may be an iferror result that needs to be unaccounted for). Attached is an image of the work. I need the average percentage of projects on design schedule for those with projects in…
-
Count if date range
I am trying to create a formula that will tell me how many tasks that contain Map that are Flagged for CSO responsible that are due in 7 days, 14 days and 30 days from the Current Date or Revised Date (whichever is the great of the two)
-
Calculating SUM pending on dropdown selection
Hey all, I'm trying to calculate a sum pending two different drop down selections but having challenges with making it work. Any help would be greatly appreciated! =IF(OR(Coverage@row = "Travel", Coverage@row = "Local", Coverage@row = "2 Locations"), (SUM([# of Shifts]@row * 12))), (OR(Coverage@row = "Planning Only"),…
-
Count sheets in a folder and/or workspace
Hello All, Has anyone found a way to count items in a folder or workspace? Thanks Kevin
-
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…