-
Getting #Invalid Data Type error in seemingly simple formula
Hi! I'm trying to get the # of days in the past a particular date is. The date in question is in a DATE type column. It is being entered via Data Shuttle Upload from an Excel sheet that is an export of a BI system. The date in the Excel is of the following format: mm/dd/yyy hh:mm The entire file, including this date column…
-
Using Index Collect formula when there are multiple matches in the source sheet. (#Invalid Value)
Hello, My goal with using INDEX(COLLECT)) was to obtain information based on 3 different criteria, but in my source sheet there are multiple matches for the three criteria specified. What do I need to add to the Index, Collect formula to overcome this or do I need to use a different formula combination? Below is the…
-
CONTAINS formula always returns no match
I have a Row Counter column created with this formula: =COUNTIFS([Task Name]$1:[Task Name]@row, OR(@cell = "", @cell <> "")) . It is designed to house row numbers so I can reference that number in another formula. I have the column Is Predecessor created with formula =IF(CONTAINS([Row Counter]@row,…
-
Formula to create symbols based on parameters
Hello Community, I'm attempting to create a formula that will create a green, red, or yellow dot symbol based on parameters and values within given cells. The formula I have thus far is below but I continue to receive error messages Any help would be appreciated. Thanks!
-
How can I create COUNTIF for current week in current year
I am looking to count how many dates fall within the current week of the current year in crossed sheets This the formula I am trying to use , but it does not work =COUNTIFS({Deviation Management - Veeva [Archive] Range 3}; AND(IFERROR(WEEKNUMBER(@cell); 0) = WEEKNUMBER(TODAY()); IFERROR(YEAR(@cell); 0) = YEAR(TODAY())))
-
Quarterly Budget with SUMIF
Good Morning, I am trying to use the SUMIF function to pull data from another sheet. =SUMIFS({Budget Requests Range 1}, {Budget Requests Range 2}, "Software", {Q/Y Lookup}, [Q/Y]@row, "") The other content is: Budget Amount (Budget Requests Range 1) Type of Request (Budget Requests Range 2) Q/Y that the budget applies to…
-
Is there an easier way to automate multiple columns from a single multi-select dropdown?
One of my teams uses a sheet to track to the status of products in every state, with a column containing a status dropdown list for each state (Requested, In Progress, On Hold, Completed, etc.). We recently implemented a form for our internal clients to submit requests. As part of this form, we have two questions…
-
Issues with Cross-Sheet Vlookup Formula
Hello, I've read a few posts about this but havent been able to solve. I'm trying to match a PO number to its job number which is listed in another sheet but get the 'Unparseable' error? =VLOOKUP([PO Number]@row, {Temp - POsJob Nrs. Range 2}, 2, FALSE)) Any tips why this might be?
-
Getting a #Invalid Data Type error when info is not present in a referenced date column
I was able to get my formula to output a modified date that is pushed out by a couple of years with the following formula, but it keeps showing #Invalid Data Type for any cells that aren't populated with a date in the referenced. This is the formula I am using: =DATE(YEAR([Install Date]@row) + 5, MONTH([Install Date]@row),…
-
Formula Help
Hi all - Our team is trying to change our color bubble formula but we are struggling and need some help from those of you that are really good with formulas. We use red, yellow, green, blue bubbles. The Column is called health. First formula question: How do we get the main parent row to average the color bubbles and give…