# Explore. Ask. Answer.

or Explore Discussions

# Formulas and Functions

Archives for June 2021

## Discussion List

• How to find specific text within a string, in a COUNTIFS statement
In Formulas and Functions
Hi everyone, I am using a COUNTIFS to search a linked sheet, with one of the conditional IFS to be if the date falls in a specific month. So Condition 1, Condition 2, Condition 3 = Must have "Jan" in referenced dates Have tried &…
Answered - Pending Review
22 15
Answered - Pending Review 22 views 15 comments Most recent by Toufong Vang Formulas and Functions
• Trying to use AverageIF.
In Formulas and Functions
Hello I am trying to make a formula that counts the average amount of time an active (open) issue takes, whilst segregating it by priority (low, medium, high). To count the total amount I used this formula: =SUMIFS({Time to fix}; {Solved…
Accepted
1 7
Accepted Answer 1 view 7 comments Most recent by Bassam Khalil Formulas and Functions
• Making parent complete if children complete BY REFERENCING OTHER COLUMNS
In Formulas and Functions
Hi. I know similar questions have been asked, but none seem to reference other columns, which is the key problem for me. Problem: In my sheet, the Health column symbol changes color based on End Date column UNLESS the Progress column is ma…
Accepted
1 2
Accepted Answer 1 view 2 comments Most recent by Brandon Newberg Formulas and Functions
• Countifs with an IF statement and dates
In Formulas and Functions
Hi, I have two dates in my sheet - a final filing date and an extended final filing date - I am trying to identify the number of advertisements that are closed (for clean ads)- I can count with this countifs statement the FFD but don't kn…
Answered - Pending Review
12 4
Answered - Pending Review 12 views 4 comments Most recent by Bassam Khalil Formulas and Functions
• Help with multiple IF (CONTAINS) AND OR criteria
In Formulas and Functions
Hello! I'm trying to figure out how to write a formula to return a value of "Open" or "Closed" when multiple criteria is met, or leave blank if N/A. Columns: "Issue Category (Consolidated)" column contains s…
Accepted
217 9
Accepted Answer 217 views 9 comments Most recent by Paul Newcome Formulas and Functions
• how?
In Formulas and Functions
I am trying to add multiple columns with certain criteria, but I get a 0 and no the actual answer. The formula I am using is =COUNTIFS({1. Tech Sonic All Incident Summary Range 1}, {1. Tech Sonic All Incident Summary Range 2}, {1. Tech So…
Answered - Pending Review
11 5
Answered - Pending Review 11 views 5 comments Most recent by Sandra Rogers Formulas and Functions
• Populating a Date field using formulas
In Formulas and Functions
Hi All, I have 2 known variables that I want to use to populate a Date field: We know the date that a Learner starts a course [Start_Date], and we know the cadence at which a report should be pulled afterward [Report_Cadence] (sometimes in…
Accepted
31 6
Accepted Answer 31 views 6 comments Most recent by Paul Newcome Formulas and Functions
• Calculating percent of a percent in an =IF(AND formula
In Formulas and Functions
I'm trying to write a formula that says if one cell is less than 30% of another cell, then note the status as "At Risk." =IF(AND([Percent Complete]@row < [Timeline Progress]@row, [Percent Complete]@row = [Timeline Progress]@r…
Accepted
11 3
Accepted Answer 11 views 3 comments Most recent by Paul Newcome Formulas and Functions
• Use OR in a formula
In Formulas and Functions
Hello. I am working on a formula and I have most of it complete. I have never used the OR function, but I think that is what I need to make this work correctly. Maybe it's just me, but I never really understand how to use it from just the …
Answered - Pending Review
1 2
Answered - Pending Review 1 view 2 comments Most recent by M. David Formulas and Functions
• Calculating markups for multiple value ranges in a single formula in Excel/Sheets
In Formulas and Functions
Hello! I'm a relative newcomer to spreadsheet formulas. I'm trying to use one formula to create standard markups for items based on fixed cost ranges. I thought I figured out how to use greater and less than in a formula and how to nest th…
Accepted
3 6
Accepted Answer 3 views 6 comments Most recent by Paul Newcome Formulas and Functions