-
Count If from Roll Up
Hi all, I am trying to count the number of occurrences of certain keywords from a sheet column into a rollup. I cannot seem to get the formulas right. Error coming up as #UNPARSEABLE Keyword "HHS", Sheet Name "25", Column Name "Funding Agency" =COUNTIF({25 Range 1}[Funding Agency]:[Funding Agency], "HHS") A little…
-
#INVALID Ref in metrics sheets
Metrics were working fine until today then the above appears in place of all formulas = dashboard not working too
-
How do I make the numeric value returned in this formula usable in other mathematical formulas?
Value returns correctly, but I need to be able to add that value to OTHER formulas and fields. =IF([Target Level:]@row = "Standard", "$19,000", IF([Target Level:]@row = "Superior", "$100,000", IF([Target Level:]@row = "Premier", "$240,000", IF([Target Level:]@row = "Elite", "$490,000", IF([Target Level:]@row = "Platinum",…
-
Edate formula
I want to calculate the contract expiry date based on the current contract term. If the day of start date <=15, the expiry date should be the last day of the previous month if the day of start date is the expiry date should be the last day of the current month any help would be great thank you
-
Sumifs, referencing another sheet with two conditions
I am trying to add numbers based on 2 conditions. I am referencing another sheet. I am using the following formula: =SUMIFS({FY21 AA AMER Budget US$}, {FY21 AA AMER Quarter}, contains "2021",[{FY21 AA AMER Marketing Cost Type}, contains "Content"]) I want to add the budget for AA AMER if the following two conditions are…
-
SUM of Only Parents in Budget Sheet
Hello! I've created a budget sheet with sub items. I figured out how to SUM the Children under a Parent line but what is the simplest way to SUM only the Parents for a Total that does not include both Children and Parents? Thank yo!
-
Nested Criteria error only for one row
Hello Community, I have a column formula that works fine for every row except one. This particular row is not any different that I can see from the others. I apologize for the length of the formula, I will do my best to isolate and breakdown the issue I am having: Here is a pic of a test column created to work out the…
-
Should I use INDEX/MATCH Instead?
On sheet A I have a date, if it falls within 2 dates I want to display a PROD date from another sheet. I can get IF/AND working =IF(AND([Testing End Date]@row > DATE(2021, 10, 1), [Testing End Date]@row <= DATE(2021, 10, 27)), {Build Release Plan Range 1}, IF(AND([Testing End Date]@row > DATE(2021, 10, 28), [Testing End…
-
Is it possible to stop a flow pulling in a duplicate line item
Hi all, Hope you are all well! With the help of this community i have created a form that will automatically identify how a line item and how long it is before being cancelled. This form will then send emails to Project Managers once we are 5 days away from cancellation and then a day away. Because of this, we are going to…
-
COUNTIFS Formula not picking up additional rows
I created a COUNTIFS Formula to tabulate results from a column containing responses from a Multi Select Drop Down Form. Once I go the formula right, it calculated correctly but as additional rows have come in to the sheet, it isn't picking up those additional rows. One cell is still showing the original value, though based…