-
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…
-
Defining a phase based on dates
Hello - I have a typical project timeline sheet with Phases and Milestones of a project. Each has a Start Date, End Date, Predecessor and Duration. For each project I have a budget sheet that list the various activities that will be performed and the forecasts cost. I need to be able to report forecasts cost based on a…
-
Status Update for Most Recent Entry in Child Rows
I'm looking to pull the "Action By" result from the most recently edited (Auto-Populated "Modified" column) Child Row and pull that Action into the "Action By" column in the (sometimes Grand)Parent Row. I have tried IndexCollect and IndexMatch and can't quite get them to work. I've also tried to use a Max (which is why…
-
EDATE, why is this not a function?
Hello, I have read several threads of people asking for this function. I am actually shocked this is not available. I need to calculate a date 45 days out from an approval date. I have tried several formulas and nothing is working. Please help..