-
COUNTIFS of a text string based on a condition
I have two text columns. One column contains titles of documents. The second column contains specifies the document's "category." One of the categories in the "Category" column is "Presentations." However, in that category are two different types of presentation: "BDM" and "TDM". Whether a document is a BDM or TDM is…
-
Automate RYG Balls Based on Two Different Dates
I am trying to create a formula that looks at two different start dates to set the project status. It looks at the first start date to see how far out (TODAY) is from that date and looks to see if there is a date in the second start date. This is what I have so far: =IF(AND([Start Date]17 >= TODAY(+28), ISBLANK([Start…
-
Presenting N/A or Entering Date in Reports
Hello, We are attempting to come up with a formula that will present N/A in a Date column if the parent column lists N/A, otherwise we want the date functionality to work by presenting a calendar the user can select the date from on their individual report. What we are running into when the report is created is that the…
-
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 =…