Formulas

Discussion List

  • Automate RYG Balls Based on Two Different Dates
    In Formulas and Functions
    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. …
    Unanswered
    2 0
    Question 2 views 0 comments Started by Hannah Bell Formulas and Functions
  • CountIf with Date range
    In Formulas and Functions
    I 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…
    3622 32
    3.6K views 32 comments Most recent by Matt Fruitman Formulas and Functions
  • If function
    In Formulas and Functions
    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…
    Answered - Pending Review
    9 2
    Answered - Pending Review 9 views 2 comments Most recent by nskoulphong Formulas and Functions
  • Formulas with reports
    In Formulas and Functions
    Hi, 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 1
    Answered - Pending Review 8 views 1 comment Most recent by Heather D Formulas and Functions
  • I'm Stumped - Need a Percent Average when applicable
    In Formulas and Functions
    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 t…
    Answered - Pending Review
    11 1
    Answered - Pending Review 11 views 1 comment Most recent by Heather D Formulas and Functions
  • IF, AND, OR Formula
    In Formulas and Functions
    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 hav…
    Accepted
    8 3
    Accepted Answer 8 views 3 comments Most recent by Heather D Formulas and Functions
  • Joining cells of multiple columns into one cell
    In Formulas and Functions
    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 f…
    Answered - Pending Review
    12 2
    Answered - Pending Review 12 views 2 comments Most recent by Ruth Schoonover Formulas and Functions
  • Querying my sheet
    In Formulas and Functions
    Hello, 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 2
    Answered - Pending Review 16 views 2 comments Most recent by AlbertoCL Formulas and Functions
  • Formula Help Countifs and Match
    In Formulas and Functions
    I'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…
    Unresolved
    15 2
    Question 15 views 2 comments Most recent by Matthew Emrich Formulas and Functions
  • SumIF from another sheet
    In Formulas and Functions
    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…
    Answered - Pending Review
    9 4
    Answered - Pending Review 9 views 4 comments Most recent by Barent Wagar Formulas and Functions