-
Getting the difference between a past date and today's date
I want to use the sheet summary to report how long a project has been put on hold. So I have the date that the project got put on hold, which is Aug 9, 2023. I want to automate the calaculation of how many days it has been at any given time. I've tried multiple formulas and none of them are working. Even typing in =TODAY()…
-
Remove duplicates based on Modified Date
Hi team, any suggestion is appreciated! I have 4 sheets: Sheets A-C: Individual project trackers Sheet D: Main project sheet What I need: Setting up a workflow that copies row updates in Sheets A-C over to the Main Sheet (Sheet D). This will ensure the Main Sheet includes all project statuses so I can report on them.…
-
Formulas to Calculate Dates/Duration
I manage an intake process and want to calculate the duration that an item is in each stage (there are 3 stages) I created 3 helper columns - Stage 1 Date, Stage 2 Date, and Stage 3 Date. I also created automation so that when an item reaches Stage 1, the date is recorded —- same with Stage 2 and 3. I need help on what…
-
Index and Match between sheets providing Invalid value
Hi All, I have a master data sheet collating uniform info + delivery addresses. All fields work but for some reason half of delivery details come as #INVALID VALUE - Not sure what is the issue or how to resolve. =INDEX({Uniform site master Range 1}, MATCH([Site SIN number]@row, {Site Details Range 2}, 0))
-
IF Formula - Checked Community and Can't Find a Solve
It will not return the N/A. I removed the quotes around N/A, added them in and it won't give me the result either way. I removed the Dropdown function on the GF Testing Required and made it to a Text/Number format but it will not return the "No" in the Form- Approved column. The formula works in Excel with the N/A in…
-
Need help with a formula that pulls from two sheets but gives #INVALID REF for one sheet
I had help a year ago to create a formula that uses a Project ID to pull data from two project sheets into a sheet that tracks project hours. I need to pull another column of data into that sheet, but my formula is only half working. It pulls from the active projects sheet but I'm getting #INVALID REF for data from the…
-
Progress with children rows
Hello all I have a tracking sheet for payments under several Purchase Orders (POs). Each PO can have different numbers of milestone payments—anywhere from one to ten or more—until the PO is completely paid. For each milestone, I need to mark it as 100% and then i need send invoice. The parent row should then show the…
-
Formule
In sheet A I have 400 lines where people have to check a box when they have received a document at the and i want to create a dashboard where we can see how many docs we rcvd back? We have three type of docs GDP TAPA FRIGO So i will have 3 colomn the result i want to see is in this case is: we had total 11 GDP docs but we…
-
Formula for Quarter & Year
I'm trying to pull the quarter & year from a column using a formula, but I keep getting "unparseable". I've searched through the community with no success using the answers found. I'm pulling data from my "Expected Close Date" column. Below is an example of a formula used. Any help is greatly appreciated.…
-
Trying to find the top three categories for Dashboard Metric
Hello, I have a list in my primary column with categories ([Primary Column]52:[Primary Column]93). The column to the right COUNT column has counts for the categories ([count]52:[count]93). I also have a ranking column next to that with the following formula in it from row 52-93 —> =RANKEQ([Count]@row, Count52:Count93, 0).…
