-
Rank based on multiple criteria?
Hello! Is there a way to calculate unique rank values based on multiple criteria? In this example, I'm attempting to rank a list of performers based on average rating. Several performers have the same average rating, so I'm using "# Reviews" as a secondary/tiebreak criterion. I've tried using "RankEQ" and "RankAVG" but…
-
Formula - Count IFS
Hello, i am having trouble with a calculation I am trying to use. The formula is : =COUNTIFS({Original Due Date}, >=[Column22]@row, {Original Due Date}, <=[Column23]@row, {Days for Deviation Closure}, >30, {Days for Deviation Closure}, <61) The calculation does not give me an error (all results return as 0, however, if I…
-
Whats the formula to find todays date between a range of dates to provide a value?
i need a formula to find todays date between the start date and end date, then provide the current sprint
-
I am trying to do multiple if statements in a formula but can't seem to get it right!
Here is my formula. =IF([Assessment Date Booked]@row > [Deadline 2]@row, "N/A", IF([Assessment Date Booked]@row < [Deadline 1]@row, "[Assessment Date Booked]@row+730", IF([Assessment Date Booked]@row < [Deadline 2]@row, "[Assessment Date Booked]@row+365"))) What it is returning is [Assessment date booked]@row + 730 but I…
-
Index - Distinct returning an error
I am using this formula to pull distinct entries from another sheet: =IFERROR(INDEX(DISTINCT({Linked Sheet Range 11}), $IDX@row), "") The entries are returning as blank - so indicating an error for the whole column. I have used the same formula in the sheet for other data ranges in the same source sheet and it's working…
-
SubTasks Due in 7 Days
Need help with a formula to determine how many subtasks are due in 7 days that are not complete. Columns are Finish (which is a date), Status <> Complete. I also have a Helper Parent Column that has no data (blank) for the main Tasks. Had a formula that used to work but no longer is producing the correct result.
-
Is it possible to have a drop down list based upon criteria from another column?
In my primary column, I have a list of countries and in the "Type of Change" column I have a drop down list from which the user will select an option specific to that country. I would like to ask if it is possible to have the drop down list only present the options based upon the country in a given row. For example, if I…
-
ISCRITICAL is FALSE for a PARENT task with CHILD tasks that are on the critical path
I have a project plan where the child tasks are on the critical path with ISCRITICAL = TRUE, but for the parent task, ISCRITICAL = FALSE. Is this expected behavior? Context: It's a waterfall project. Only the child tasks have predecessors and successors so that the dates and duration for the parent task adjust when the…
-
Cell has multiple data?
Hello, Hoping someone could help with a simple formula from another sheet that has multiple drop downs? =COUNTIF({DATA COLUMN}, HAS(@cell, "ICM" + "PCM")) I want to count how many times "ICM" and "PCM" appear together in a drop down cell from another sheet. They could be selected individually which i dont need just when…
-
If or Collect statement to bring back correct pricing
A vendor has given us a step price increase over the next 3 years. But I can't figure out the best formula to bring back the correct pricing. I have 13 sheets that will reference this sheet for pricing. In order for the pricing to generate for our use, I need it to be correct for the year. It's going to be complicated.…