-
Multiple IF statements
Hello, I'm trying to populate a follow-up date depending upon the status. My formula works for one criteria: =IF([Sales Status]@row="Hold for Future Follow-up", TODAY() + 90) When I try to add on another IF statement, I get an error (I have 5 IF statements to combine). Each part of the formula works perfectly on its own.…
-
COUNTIFS range formula while referencing another sheet
Hello, I am unable to figure out how to count the total number of cells that are in a certain status AND range between 31-60 days while referencing another sheet. I have used the formula below to get a total when a cell is in the "Assiged" state AND is less than 30 days and it worked. I've also provided a screenshot of the…
-
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…
