-
Project status synchronization between 2 sheets
I have 2 sheets (2 project trackers) and need to present the status in a "master" tracker based on a data from the "slave" one. The problem is that in the slave there could be couple (even 20) rows that are connected to the one project in the master file. They are connected via Project Name column. I need to somehow merge…
-
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…
