-
How to import data from other sheets?
Hey all. So I am looking to set up 2 sheets for inventory tracking. The first sheet will be a 'database' of SKUs along with item manufacturer names, model numbers, SKUs etc. I want to use that database sheet to feed my inventory tracking sheet. Ideally what I'd like to set up is: Item Sheet: select SKU-001 Sheet references…
-
parent child vlookup
Is there a way to use a sheet that has parent-child as a Vlookup for another page?
-
Sort data from a JOIN(COLLECT( formula within a cell
I have a formula in one of my sheets that looks out across multiple columns and populates the cell with all values present in the columns for that row. I simplified the column names to make it easier to read, but here is the formula: =JOIN(COLLECT([Data1@row:Data5@row, Data1@row:Data5@row, <> ""), ", ") My question: Is…
-
Latest Date Formula
Hi I want to find the latest date a review was done on a file number. Multiple reviews could have been done on the same file so, I only want the latest date. I have used: =INDEX(MAX({01.SHEET: File Review Range 1}, MATCH([Matter Number]@row, {01.SHEET: File Review Range 2})), 0) as I am referencing the File Review sheet…
-
Hi All, I tried a nested IF AND & IF OR formula but it is showing as #UNPARSEABLE error. pls help.
Below is the formula I am using. =VALUE(IFERROR (IF(AND(Level@row = 1, (IF (OR(column@row = "Test 1o1", column@row = "Test 2 of 1",column@row = "Test 3 of 1", "31"),(IF (OR(column@row = "Test 1o1", column@row = "Test 2 of 1",column@row = "Test 3 of 1", "41"),(IF (OR(column@row = "Test 1o1", column@row = "Test 2 of…
-
Reversing WEEKNUMBER Function
Hi all, I have a few values corresponding to different dates, and I would like to group these dates by their respective weeks. What I am thinking of doing is using the WEEKNUMBER function to generate what week they are in, and then grouping them using this number. Additionally however, I would like to group them by the…
-
Reference date above to carry on sequence when row moved
Hi Sorry to go into an old post but this is what I want, to look at the dates. I want to look at moving rows which have sequential dates based on planning. =WORKDAY([Online Date]248, 1, {Holidays Range 2}) I also want this to inherit from the date above to repopulate the sequence in order as shown Currently, if we move a…
-
Show my "up next date" based on the child-parent task relationship?
Hi! I've been using the MIN and MAX children functions to roll up dates from child tasks, or sub-tasks, to the parent task. I also want to create a column that looks at the dates of each sub-tasks and grabs the one closest to today's date so I know the "next upcoming due date" among a parent's children/sub-tasks. What…
-
I'm getting an "Invalid Data Type" error
Hello, I'm trying to count all rows (using a cross-sheet reference) which have either "Discovery Call - Scheduling" or "Discovery Call - Scheduled" in the Sales Status column but am getting an "Invalid Data Type" error. Thanks you.
-
And, Or, NOT(isblank) Formula help needed
Hi, I'm attempting to write a formula that would check a box in a specific column if the [De-prioritized?[check if yes]] column is checked OR the [Date Marked Complete] Column is NOT blank and [Date Marked Complete] column has a date more 30 or more days in the past. Below is what I came up with, but am receiving a…