-
Combining Form Submission Data with Already Existing Row Data
Hello All, I'm looking for a way to combine form submission data with data that already exists in a row. For example my row has the item information for something we're trying to resell. The form goes out to the resell companies for them to make an offer. If an offer is made its populate on a separate row. Would love to…
-
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.