-
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…
-
How to apply dashboard level filter ?
How to apply dashboard level filter ?
-
Index/Match Error
Hello- I'm trying to use INDEX and Match in lieu of vlookup. my formula is: =INDEX({V.9 IP Fit Test Results Range 3}, MATCH(EID@row , {V.9 IP Fit Test Results Range 4}), 0) but it's populating a lot of my cells with the same date even though some of them should be dated a month earlier if i manually do a search on the…
-
Count Children Rows
I'm adding formulas to the sheet summary to count the rows per parent on a sheet. I have the below working: =COUNT(CHILDREN(Region163)) =COUNT(CHILDREN(Region184)) However the number of rows under each parent may change and so I cant rely on row 163 or 184 being the parent rows. So I tried the below:…
-
Formula Help for Displaying Column Text
Hi all, I am creating a sheet and need to display names from a reference sheet if the text value in the same reference sheet is true. Here is an example of my reference sheet: Manager ProjectStatus Joe Smith Not Started John Example In Progress Jane Doe Complete In my sheet that I'm creating the database in, I need compile…