-
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..
-
Red, Yellow, Green, Blue
=IF([CEO Approval to Re-Open]@row = "Approved", "Green", IF([CEO Approval to Re-Open]@row = "Declined", "Red", IF([CEO Approval to Close]@row = "Declined", "Yellow", IF([CEO Approval to Close]@row = "Approved", "Red", ISBLANK([CEO Approval to Close]@row = " ", "Blue", ISBLANK([CEO Approval to Re-Open]@row = " ",…
-
Cell linking issues while filling from from
Cell linking is disappearing automatically when we fill out the project intake sheet form. I have a project intake sheet that I use to feed new project information and from project, metadata sheet to the project intake sheet I created link to get the data when the project intake form is filled, but this is not working