-
Rolling Year Formula
I have a file that will be used to calculate 13 rolling periods for graphs and reports. The file contains 13 rows only for the number of months needed in the reports. I need a formula that will enter the year number in the "RollingYear" column. I have the formulas for the needed month number. The start calculating from the…
-
Formula not doing basic math correctly
im trying to build a metric for a dashboard that finds the percent difference between the actual and the required amount. for some reason going =[Required Capacity]@row / [Actual capacity]@row gives a different answer than =140.5/145.3
-
FILTER function
Is there an equivalent of the FILTER function in Excel? =FILTER (array, include, [if_empty])
-
Removing Duplicates
Hello, I have a sheet that I am going to import data into via Data Shuttle that contains a list of requests that need to be approved by a manager. Once the data is imported, I am going to set up an automation that sends an email notifying the manager they have a pending request. The challenge is one manager's email address…
-
Checking for duplication across two fields
Hi Community Have used the formula posted to this forum to identify duplicates in a single column using [IF(COUNTIF())} formula. I have a site/dept type issue split across two columns and need to identify when the same site/dept combination has been used in another record. I have tried using AND in the COUNTIF() but just…
-
Select Value, not the formula, in a cell.
Hello, I have a cell where I join a column of cells with keywords into a single cell. This combines the keywords from all the entries on the sheet into one cell for use in analysis of all collected keywords. I want to copy the combined keyword list, but I can only seem to select the formula that is generating said list in…
-
Extracting Month from Date
I would like to filter records based on a date in the past whose month falls within the next two months. For example, if today is 1/26/23, all records that fall between today and March 26 (i.e. 2/1/2019 would filter through). I can't figure out how to ignore the year (which will always be in the past).
-
RYG ball to determine priority involving multiple dates
I have a sheet that lists all active contracts for my department which all have expiration dates. However, I am struggling with this sheet because in all calculations I need to consider any extension dates. I do fine with calculations when there is one date involved but when I need to write them to incorporate two and…
-
combining vlookup with sum formulas
Hello Everyone, I am stumped again like usual and looking of help with getting a formula right. I am creating a data analysis sheet to generate sums and averages based on another sheet which has raw data. I understand how to do a sumif formula and separately how to write a vlookup formula, but I am struggling to combine…
-
Using COUNTIFS With Contacts, CONTAINS, and OR
I'm essentially trying to make a sheet summary formula for how many open cases someone in a contact list has at the moment. I've got it working when I'm looking at the contact list one way, but the users of this sheet have a bad habit of entering data so that their email address displays in the contact list rather than…
