-
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…
-
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…
-
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).…
-
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.…
-
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…
-
How to assign points to answers selected thru drop down on form
Hello, I created a form to be used during a training exam. Each cell has a drop with 3 options, Proficient, Needs Improvement, Not covered. Is it possible to assign each option a point value ( 3 - proficient, 2 Needs Improvement, 1 not covered) and have a total calculated once completed? Thank you
-
A True Mind Bender - Tracing Tasks through Predecessors
Is this even possible? I have a task (say Task 18) that is preceded by other tasks, all joined by predecessors. Task 18 is the "final" task. Task #18 is preceded by Task 16, and Task 16 is preceded by Task 14. Outcome - I want to filter rows to see only the tasks that have a relationship to "Task 18." I'm thinking that I…
-
how to combine multi formula conditions
Hi team, Trying to create a vehicle luggage capacity calculator for small and large cars, Please find below, Please find the below Formula: =IF(AND(Passengers@row <= 4, [25 Kg]@row <= 2, [15 Kg]@row <= 1, [7 Kg]@row <= 1), "Yes", "No") The formula above indicates the col [Result] is "Yes" in the ase of follows: The number…
-
How to get Join Collect formula to work
I have a sheet (picture attached) where I am trying to show all of the tasks dependent upon a certain task from being done. I want to sue a join Collect formula to list out all of the tasks referenced in the the predecessor column that match the row #. For example, in the picture, Row 70 would show the task "eComm Mezz…