-
100,000 reference limit for big data sheet. How to save references?
Hi all, I have a big data sheet - insurance claims. When the client fills out the insurance claim, it writes the insurance number in forms, which then is used to search for data to be pulled from 11 other sheets according to this number. I have approximately 35~ columns that need to be filled. What I did is index every…
-
Form Logic - AND?
Hi, Having an issue with Logic within Forms. I have 2 situations where the logic doesn't seem to be going my way: I have 4 types of NCF, which control the majority of follow up questions: Purchased Parts Sub-Assembly Customer Supplied Finished Goods Selecting either, allows the CT/Commercial field to open, I then want this…
-
SUMIFS formula that skips children rows and is based on YEAR and MONTH
Hello! I have a problem trying to make a formula work. The sheet I want to take metrics from has a "value" column and a "date" column. On some places in the "value" column there are Parent rows that sums the children rows. I want to make a SUMIFS formula that can Sum the total Value based on YEAR and MONTH but not SUM…
-
Only first 100 values dropdown list in forms
Hi, something very strange in a sheet we have. A column with the type = Dropdown list and about 200 values , restrict to list values only. shows only in the form the first 100 values. When I do this is a new sheet it's working? Is there a sheet limit or column limit? regards jan
-
Return the cell with a value from 3 cells
Good morning all, I can't get my head around this one so wanted to see if anybody can help. I have 3 columns: Downtime Start Time OOO Start Time Manual Downtime Start Time I would like a formula in a different column that searches all 3 of these cells and returns the first one that isn't blank. Is this possible? Thank you…
-
COUNTIFS using today's month
Hi I'm currently trying to count the number of jobs, matching a specific work type when the received date matches today's month. I am referenced another sheet (Job Log) also. The formular I am currently using is: =COUNTIFS({Job Log l Job Type}, [Job Type]@row, {Job Log l Office}, "Birmingham", [{Job Log l Date Received},…
-
Formula to show if a single contact list entry exists in a different multiple contact list entry
Long time fan, first time community poster, but I have a formula help request. See the screenshot of what I am trying to accomplish. Basically I have three columns. Column 1 = Single Contact list that will always have a contact (In this example we call them "Person A") Column 2 = Multiple Contact list that will have 2-4…
-
Find first non-blank cell with INDEX/MATCH
Hi guys! I'm pulling 2 columns, each with multiples of the same value, and some rows have blanks in the cells until the reference sheet is updated with said information. My INDEX/MATCH works great, except there it pulls the blank values, and thereby reducing the accuracy of my sheet. The formula is as follows;…
-
Autofill contact details
Hello all, I'm trying to create a formula to "Autofill" contact (Name, phone number & Email), What is the smartest, fastest way to create a formula for over 500 contacts? Thank you
-
Moving data from client report to my template
Hi - I'm importing client data to a template and I am using INDEX and MATCH formula =INDEX({Crane Range 6}, MATCH([Contra Firm / Sponsor Acct #]@row, {Crane Range 2}, 0)) This works well for one column at a time. I want to capture multiple columns at once so I'm not copying first name, middle name, last name, street…
