or Explore Discussions

# 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…
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 …
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…