-
maintain row order INDEX - DISTINCT
I'm pulling index/distinct from one sheet, and the same from another sheet. Then index/distinct/collect to have the master distinct list from both sheets. In another column, each distinct entry in the master column is assigned a number (1-5). This number is then pulled back into the original sheets for hierarchy reference.…
-
Trouble gathering a SUM from another sheet.
I've been running into an issue where I have a sheet that gathers all information from a form. Im trying to gather a sum of a total of a column, but only reference the values of specific rows that from column. Example: I have Column to indicate "fixture color" that will be a specified by the form. I want to sum another…
-
How to create a formula that is looking at an end Date and working back to a Start Date
Hi I currently have this formula =[End Date]@row - 210 the 210 is basically 7 months, however I want it look at a different column that has a number in it (ie 24) for 24 months and work back to what the Start Date should be. Thanks😀
-
Calculate time between start and stop
Hello - I thought this would be an easy formula but it keeps returning at invalid or unparsaeble. I am trying to find the difference between stop time and start time - when I enter the Stop time on line 25 (2:44) and then I enter the next start time on line 26 (6:33), it automatically calculated "Time Between Cycles" as…
-
change cell value in a date Column via automation
Hi Community, following szenario: I have a helper checkbox column "Has CHildren" indicating, if a parent row (Generation 1) has any children rows (Not all rows will have sub rows) If so, I want to change the value in the column "Due Date" via automation to =MIN(CHILDREN() to automatically show the next due date of a sub…
-
Count multiple criteria across many sheets.
Hello all, I could use some guidance on next steps for a project I’m working on. I have a template sheet that will be used for each individual project. Within each sheet, I’m tracking metrics such as status, assigned individual, deliverable types, and audience. What I’d like to do is count these metrics across all projects…
-
Need help w/formula
I need a fx to do 2 things (AND…) I have 2 columns (below) that need to calculate: Annual Cost (Current) - Annual Cost (Proposed) AND I need the $ amount (if negative $$$) to show as parenthesis instead of a - column 1: Annual Cost (Current) column 2: Annual Cost (Proposed) My current SUM is below: =SUM([1. Annual Cost…
-
One of my criteria is one of many listed in a dropdown column and CONTAINS/HAS are eluding me.
Hello! I am working from a single "Master Sheet" and utilizing INDEX/COLLECT to pull the desired info onto separate sheets. I am utilizing "Feature", "Level" and "Product Line" as my criteria, however the "Product Line" is a multi-select dropdown column with anywhere from 1-10 values in it depending on the products usage.…
-
Evaluating Training Status
I'm working on a "user safety training record," sheet. I have multiple other training assessment sheets that when completed, index/match to an employee number row and complete the training column/field [Orientation], [Trng 2], [etc]. If an employee has completed all the training successfully, they get "Green" symbol in…
-
Early or Late for finish date based on Due date
I have to be closed. I am comparing finish date is equal or less to due date "OnTime" if finish date is after due date, "late". I'm first making sure the finish date is populated. =IF([Finish Date]@row <> "", IF([Due Date]@row < [Finish Date]@row , "On Time", "Late",), " ") Please let me know what I may have done wrong in…