Formulas
Discussion List
-
Automate RYG Balls Based on Two Different DatesIn Formulas and FunctionsI 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. …
-
CountIf with Date rangeIn Formulas and FunctionsI am trying to count the number of requests types between a date range. This is what I thought would work: =COUNTIF(({Request Tracker Range 4 - Request Type}, Category5), AND({Request Tracker Range 3 - Date Requested}, DATE(2019, 01, 0…
-
If functionIn Formulas and FunctionsHello, 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…Answered - Pending Review 9 views 2 comments 0 points Most recent by nskoulphong Formulas and Functions
-
Formulas with reportsIn Formulas and FunctionsHi, I've combined two sheets into a report and I was hoping to do a summary sheet with various sumif formulas based on the data in the report. When I build the formula, the report is not an option in the list. Please advise. Thank you!Answered - Pending Review 8 views 1 comment 0 points Most recent by Heather D Formulas and Functions
-
I'm Stumped - Need a Percent Average when applicableIn Formulas and FunctionsI 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 t…Answered - Pending Review 11 views 1 comment 0 points Most recent by Heather D Formulas and Functions
-
IF, AND, OR FormulaIn Formulas and FunctionsHello, 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 hav…
-
Joining cells of multiple columns into one cellIn Formulas and FunctionsI 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 f…Answered - Pending Review 12 views 2 comments 0 points Most recent by Ruth Schoonover Formulas and Functions
-
Querying my sheetIn Formulas and FunctionsHello, i have these two columns: ESTIMATION PER HOUR (number) RESOLUTION (numbers) I want to query the sum of all ESTKM2/H matching if RES=5 and divide it by the number of items matching this query. In the end i want to calculate the mean …Answered - Pending Review 16 views 2 comments 0 points Most recent by AlbertoCL Formulas and Functions
-
Formula Help Countifs and MatchIn Formulas and FunctionsI'm trying to develop a cross sheet formula that will give me an error message if I've over-allocated equipment. This is What I've come up with so far but I get Incorrect argument. =IF(COUNTIFS(MATCH([Equipment Required]@row, {Equipment T…
-
SumIF from another sheetIn Formulas and FunctionsHi, 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…Answered - Pending Review 9 views 4 comments 0 points Most recent by Barent Wagar Formulas and Functions
