Formulas and Functions

Archives for July 2021

Discussion List

  • Finding Distinct Values in Two Columns
    In Formulas and Functions
    Hi, I was wondering if it was possible to find the number of distinct values in two columns. In this case I am looking to find if there is an overlap between start and completion dates for a given crew lead. Is there a reason that I am g…
    Accepted
    23 5
    Accepted Answer 23 views 5 comments Most recent by Brett Wyrick Formulas and Functions
  • Referencing 2 ranges in another sheet
    In Formulas and Functions
    Hi all, I'm trying to use data from another sheet to get a count. I have 2 relevant columns in the reference sheet, Name and Date. I'm trying to count the number of dates for a given name in the last 30 days. Here's the formula I'm trying …
    Accepted
    12 2
    Accepted Answer 12 views 2 comments Most recent by LeeR Formulas and Functions
  • How may I extract only the numbers from a cell?
    In Formulas and Functions
    I need to extract 16 and 9. As you can see the number characthers may change (I may have 1-2 digits) but always at the beginning. Thanks
    Accepted
    17 2
    Accepted Answer 17 views 2 comments Most recent by Enrico Trovato Formulas and Functions
  • Using reports
    In Formulas and Functions
    I have a sheet that is updated daily. I am trying to create a report that shows the previous 7 days worth of entries. I could not figure out how to do this so I created a helper column that checks a box for items that have a date up to 7 d…
    Accepted
    18 6
    Accepted Answer 18 views 6 comments Most recent by Andrée Starå Formulas and Functions
  • SUM Formula Does not work with Quarter Formula
    In Formulas and Functions
    This is my test sheet. I have the following formula in Quarter column: =IFERROR(IF(MONTH([Contract Acceptance Date]@row) <= 3, "1", IF(MONTH([Contract Acceptance Date]@row) <= 6, "2", IF(MONTH([Contract Accepta…
    Accepted
    26 2
    Accepted Answer 26 views 2 comments Most recent by Andrea Westrich Formulas and Functions
  • Lookup and Return newest Date
    In Formulas and Functions
    Hi there, looking for assistance i am trying to create a formula I want to reference a second Sheet called "Medical/Lost Time" Id like it to look up the Shift entered in the Shift column and return the newest Date from the Injur…
    Answered - Pending Review
    29 4
    Answered - Pending Review 29 views 4 comments Most recent by Scott Johnson Formulas and Functions
  • Cross Referencing with IF(AND
    In Formulas and Functions
    Hi, I am simply trying to grab data from one sheet and add to another. I've done this many times before but can't seem to get this one to work. I just want to populate the first sheet below with data from the second. For example, the nu…
    Accepted
    17 4
    Accepted Answer 17 views 4 comments Most recent by Bassam Khalil Formulas and Functions
  • COUNTIFS incorrectly counting number of times a contact appears in Assigned To column
    In Formulas and Functions
    I am trying to track the number of tasks each employee is assigned to. In my Assigned To column, some cells have one contact assigned to a task and others multiple contacts. I am currently using the following function: =COUNTIFS([Assigned …
    Answered - Pending Review
    22 3
    Answered - Pending Review 22 views 3 comments Most recent by Bassam Khalil Formulas and Functions
  • Count Parent rows and rows without children
    In Formulas and Functions
    Hello, We have an archive sheet where all completed projects are automatically migrated via "move row" workflow. Some projects have multiple child rows while some do not have any. I would need a formula to count a total number of…
    Answered - Pending Review
    16 3
    Answered - Pending Review 16 views 3 comments Most recent by Andrée Starå Formulas and Functions
  • formula
    In Formulas and Functions
    Hi Guys I am needing help with another formula, in another sheet I want to extract data from the sheet above I want to get an average of days (green Highlighted amounts) is IF DEPT contains REF what is the average of Green Highlighte…
    Accepted
    18 6
    Accepted Answer 18 views 6 comments Most recent by Bassam Khalil Formulas and Functions