-
Index; Match formula - 1-5 star defaults
Hi everybody; it is always a happening when huge formula is working as the following one: But for any reason the formula works when I set "Kundenrelevanz" to 1,2 and 4 stars but if I change to 3 or 5 stars there is "no match" Any idea why it is ... ?
-
Fomula cross sheets | lead scoretable
For any reason this formula does not yet work properly. Has anybody an idea? Furthermore, do you have proposals for more KPI´s or sheets you can share?
-
INDEX/MATCH - I want to return a blank cell if another cell is also blank
Hello, thanks in advance for the help. I am using a DISTINCT formula. Then I have an INDEX/MATCH formula in the next cell, pulling in from a different sheet. I have the IFERROR part programmed, but I would also like it to give a blank cell result if there is not a number in the "Harvest Batch Name" column. This way, If I…
-
Column Formula Not Filling All Rows
I have a column formula that isn't filling all rows. I have a row id with auto numbering and it's only going to 4 rows. I need it to fill in the whole sheet so that my index match formulas can look up if another row is created in another sheet. I'd like to get the auto numbering column to continue filling in the rows for…
-
Calculating pro-rated values for every month
In the below schedule of values, the $ value of each child task is the parent value multiplied by a weight. For forecasting purposes, let us assume that 25th of every month, each line item is billed depending on the whether the start and finish dates fall within the period. In the below example, activity on Row 20, is to…
-
Having trouble with IF(AND
I have 2 columns of dates; Column a = Target Date Column b = Actual Date I want to turn a cell 'Red' if Actual Date is blank and Target Date is either today or past. The above formular returns 'INCORRECT ARGUMENT SET'.
-
Formula to collect resource's start date
Hello, I am trying to create a formula that will collect the min. date for the resource listed at row for various projects. If the resource isn't listed as a task owner, Right now, I am getting a blank response instead of my initial start date for a project. Current Formula: =IFERROR(IF(CONTAINS(Resource@row, {Task…
-
Level Formula Not Working
Hi! I have been using the same level formula for a while, but for some reason on a newly created sheet, my formula isn't working, and I can't figure out why. Here is a screenshot of the relevant columns: The formula I've entered is: =(IF(COUNT(CHILDREN([Study Protocol]@row)) > 0, COUNT(ANCESTORS([Study Protocol]@row)) +…
-
Auto Fill with Dates if certain category is selected
I am trying to figure out how to have certain cells auto fill with a generated date if a certain category is selected. Example: If "communication" is selected, I need a cell to auto fill with a date that is a week earlier than the "due date" column. Is there a way to do this? Thank you!
-
Count Data Based on Values in 2 columns
Hello, I am trying to input a formula to count data in a column if certain criteria are not met in another column. I cannot seem to get it right. This is what I have: =COUNTIFS({Qty. Res. Planner 2023 Range 1} CONTAINS("I", @cell)), AND{Qty. Res. Planner 2023 Jan 22} NOT(CONTAINS("OUT", @cell))) I have data in column 1 and…
