-
Help Searching Mutiple Job#
I want to be able to insert in my table the information: PO,Project Description,Customer,Payment Teams,Business Unit,Submitter,Notes from anothe sheet that contains the Job information. From the Job# column, I've done it before with an index match but only when is one project. I want to be able to do it for multiple Job…
-
COUNTIFS with OR
Hello, I have spent hours trying to figure out what I am doing wrong, but I cannot seem to figure out what would get this formula to work. I am trying to count if my Simulation column says Phillips, the complete checkbox is checked and Type is Pilot OR Simulation. The formula works fine up until I add in the Type being…
-
Identify Quarters based on date AND add text if cell is not a date
I am wanting to identify a quarter based on a date and have that formula working, but I also want it to return a value of "TBD" if the Start Date is not a date AND return a value of "Dates Invalid" if the Start Date is outside of the current year, which in this report is 2023. How can I adjust the formula below to…
-
How to use symbols with formula
=IF(["Will Call" Trips]@row < ["Will Call" Goal]@row, "Yes", "No") What do I use if I want the symbol to be Hold if the answer is zero?
-
Index/Match Row ID
Can anyone explain why this would not work? =INDEX(EQ:EQ, MATCH([Row ID]@row, [Row ID]:[Row ID], 0)) It gives me #No MATCH. I realize that's a silly formula but my original formula was this: =if(LEFT(EQ@row,1)=4,INDEX(EQ:EQ, MATCH([Row ID]@row-1, [Row ID]:[Row ID], 0)),"") It literally worked and then suddenly switched to…
-
"Changes to:" Option Not Showing Up In Automation
Hello, This is not populating when I am trying to add a specific person from a dropdown list: The goal is to select certain team members that will be involved on a project so we can send rows (tactics/projects) to team member's sheets from the project lead's sheet. Can you help? Thanks, Ryan Holguin
-
Too many cells referenced - Need formula revision suggestion?
Hi, I hope some of you all had a great Engage. It was my first and very helpful. As soon as I got back, I started using DataTable to solve for a big problem I've been having with a voluminous sheet, but found that my formulas are still too referential ... according to the warning below. The TLDR is that I think my formulas…
-
See if a date is with a defined date range
Hello, I'm trying to create a formula to see if a date with in a date column is within a defined range. It's partly working but the outcome seems to ignore years (returning a result if days/months match) and it dislikes December all together returning nothing. The formula is - =IF(AND($[Column18]@row >= [Sep 2023]$2,…
-
Unparseable Multiple IF functions within one equation
Hi, I am trying to put multiple IF functions in one equation and it doesn't seem to be working. The formula should return differently if: 1) the program type is "Active" 2) the program is a virtual program and not a Youth & Adult Program 3) the program is a virtual program and is a Youth & Adult Program 4) Otherwise (The…
-
Multiple IF functions within one equation?
I am trying to use multiple IF functions within one equation and getting an unparseable error! This function should return differently if a program is U12 type "Active", if it is not "Active", is "Virtual" and not "Youth and Adult", if it is "Virtual" and "Youth and Adult" and if otherwise (not youth and adult, not virtual…