-
Combinging two IF statements
Hi, I need help combining two IF statements. They are constructed the same, but I want them to be one entire formula for a specific cell rather than two seperate formulas. They both work serpartley, but I keep getting errors when trying to combine them. Essentialy, it is when the Department column is blank it will…
-
Using COUNTIFS and NOT together
I am using the following formula and getting an error: =COUNTIFS({Master Discrepancy Log 2021 Owner}, $[Primary Column]@row, {Master Discrepancy Log 2021 Product Type}, "Prime Share", {Master Discrepancy Log 2021 Month Opened}, 2, {Master Discrepancy Log 2021 Year Opened}, 2021, {Master Discrepancy Log 2021 Discrepancy…
-
Parent Status Updated based on Child Status
Hello! I'm sure this is a super simple formula but I can't figure it out. I would like to update the parent row status to say "FILLED" if a child row has a status of "HIRED", otherwise the parent row is "OPEN". I also need to overwrite the status of the parent row if there is any case where the status needs to be "ON HOLD"…
-
How to return specific Column from a Multi Column Cross Sheet Range
Hi Folks, I have the following formula used to track specific assets: =SUMIF({EventDate_req}, $DateNeeded$1, {Asset2_Range}) This adds up the count in each row in the Asset2_Range that matches the date needed. We created individual one column ranges for each asset (Asset1, Asset2, Asset3) etc. Problem is we are using too…
-
IF Statement and RYG text values
Im running a routine to identify when a record changed for assets and flag it based as follow If the Values on Current Status and New Status are the same then GREEn If the Values arent the same RED if Current Status has any value and New Status is equal #NO MATCH then I wanted to be Yellow but it is not working no matter…
-
Formula to stop Date Countdown
Hi! See attached pic I have struggled with this formula and not had any success to get it to do what I want. Current formula is: =[DUE DATE]@row - TODAY() ...this gives a handy countdown. In the pic you can see the first line should not still be counting down as the task was completed 12 days ago. What I need it to do is…
-
Filter Helper Question
Hello, I am tracking communications for my project, and each row represents a communication (e.g., notify employees of changes to expense policy). I have separate date columns for "Draft Due" and "BU Review Due" and "Legal Review Due" and "Distribution Complete" (see attached). I want to have a filter to show me any rows…
-
Most Occurring Value Based on Multiple Criteria
Our organization is counting how often we interact with clients weekly and that process is going great. What I want to do is show who contacted the most clients during a particular week. We have a data dump master sheet and a sheet where I consolidate some high level data. With this one I don't even know where to start…
-
Matching data from one column in Project Intake Sheet to another column in Project Metadata
Hi so I am currently redesigning a project tracking system for a company. I downloaded the PMO template set to use to get a foundation but it will not track the data i need it to track. Basically what I need help with is I have multiple columns in the Project intake sheet that will have simple data put in them like dates…
-
#INVALID OPERATION is trying to break me
This formula is wrecking my day so I am waving the white flag and asking for help... I am attempting to display the LOG 2 "Title Company" where the LOG 1 FC Start Date (020) .GT/ET. the LOG 2 "Effective Date" and LOG 1 FC Start Date (020) .LT/ET. the LOG 2 "End Date" and LOG 1 "Property State" = LOG 2 "Property State".…