-
Multi conditional formula affecting the "Status" on a Project Plan
Hi There Can one have a formula in a project plan that says if the "Activity " column is "Project Task" and the "% Complete" 10%, then Status is "In Progress". However, if the "Activity" is changed to "No Longer Applicable", or "Hold" - the "% Complete" remains unchanged, but the Status is then either "No Longer…
-
Help to count a column where neither 'Complete' 'Canceled' checkboxes are selected
Hi all, I am trying to build a formula that references another sheet, mostly focusing on 3 columns in that sheet: At Risk (symbol) | Completed (checkbox) | Canceled (Checkbox) I am trying to count all the values in the At Risk column where neither Completed or Canceled checkboxes are selected. Basically, I'm trying to…
-
Formula Help
I am getting an incorrect argument error with the below formula. I am trying to collect data from different sheets based on whether the cell value in the Airside / Landside column is Airside or Landside. =IFERROR(IF([Airside / Landside]@row = "Airside", INDEX(COLLECT({EqNo}, {Employee ID}, [Employee #]@row), 1),…
-
Issue using COUNTIF function with OR condition where OR is reference to different sheet
I am trying to use COUNTIF function with OR condition where the OR is referencing to different sheet. It’s the OR that's causing me issues. When I refer to same sheet reference its working fine but when I use different sheet reference I get “#Invalid Operation” error. Formula that I am using is =COUNTIFS({Primary_Owner},…
-
RGY Health Formula for Status and Due Date
I'm struggling to complete a formula to do the following: If Status is Complete, mark the health green. If Status is Not Started or In Progress and End Date is 10 days or greater, mark health green If Status is In Progress OR Not Started and End Date is within 5 days, mark the health yellow If Status is Not Started OR In…
-
Check a Date Range
I need help with defining a formula to evaluate a date. I have a “Date” column which contains a mm/dd/yy date. I want to evaluate that column to return “Yes” if the date is within the current month and the next 60 days. For example: “Date” = 07/10/22 Today’s Date = 07/22/22 Is the “Date” within the range: 07/01/22 –…
-
Which count formula do I use?
Hi, I have two sheets. The first sheet changes daily the words passed or failed depending if the item passed or failed our process. On the second sheet I need a daily count of how many items pass and how many items failed. This sheet needs to updated daily depending on how many passed or failed their are. I've been reading…
-
Want to count number of instances in a column
HI There, I have one column in which I track the status of each row with a traffic light (Red, Yellow, Green). I would like to count the number of Red's, Yellow's and Green's in the column so I can use this information in a dashboard/portal to show the number of each color/status. I have triied a few things, but I am…
-
check box if date is 90 days prior to today
Hi! I'm trying to have a box checked if the Due Date is 90 days out. I seem to have that part right =IF([RR Due Date]@row <= TODAY() + 90, 1, 0) But it's checking all boxes if they are blank. What can I add to the formula to ignore boxes that are blank? Thanks so much!
-
SUMIFS total for data within last 30 workdays
Hello, I've read multiple questions regarding getting a return of SUMIFS for a set date range. I however can unfortunately not seem to get my function to work. I am attempting to get a sum on the total number of orders done within a specific hour over the last 30 days. I have a form that feeds in data that tracks orders…