-
COUNTIFS , based on previous days - not including current day
my current formula is =countifs(field:field, (@cell > TODAY() -7),….. or (@cell> TODAY(-7)…this comes back with a total that included today. Is there a way to count the seven days prior but not count the current day in the formula?
-
Seeing #UNPARSEABLE issue when applying formulae in the summary
Wanted to calculate the Average of time difference with some conditions like Implemented column is checked for the Level 1, and the final Level2 task is completed, then calculate time from the dates in the final level2 task called 'ECO Implementation". Here is the formula I generated but I see #UNPARSEABLE error.…
-
I need help with the RYGB Status Balls formula
Hello, I am trying to calculate health status (RYGB) for each task and milestone. Red= Not Started and past due, Yellow, In progress, but % complete is equal to or lower than 48% (.48), Green is in progress, % complete is equal to 60% or greater and blue is completed. I have read through many posts, but cannot seem to find…
-
COUNTIF between date range and 2 criteria
I am trying to cross reference another sheet to count all of the projects assigned to a specific person in between a certain range, but the # of projects assigned and the person assigned to the project are 2 separate criteria. For example, I want to know how many "A" projects that Jane completed in the month of January. I…
-
Formula help with adding up total $ in one column and associating it to the right business unit
I am having trouble coming up with the right formula for a sheet. I am referencing a sheet to create a formula in another sheet. In the sheet I am creating the formula in, I am trying to calculate (from the reference sheet) the cost by business unit. Here are the two columns I am trying to create the formula for: I need…
-
Linked Cells Don't Match
Hello! I am attempting to link cells (Duration, Start, Finish) from a project's sheet to a master sheet. However, once I link the cells, the Finish date is different on the master sheet than what has been entered in the project's sheet. Cells in project sheet: Cells in master sheet: The Finish date should be 1/2/23, not…
-
Need an equation to count text from a column with multiple selections
I'm having the issue of getting an equation to work properly in order to get a count on text in a drop down list of items. For example: I need to count how many times "Electrical" or "Paint" is mentioned in the same cell for the whole column. I keep getting error messages. The only equation that I could get to work would…
-
Creating an Automation based on days
I'd like to create an automation to send a notice to a coordinator when days worked are within 2 days of Days allowed to work. I'd also like to add a conditional format that highlights the row. Please help.
-
Is there a way to reference the row above?
I'm trying to mark active child tasks in an overall task. I'd like do =IF(Done@row-1 = 1, 1, 0) in the Active Task column, but we often insert tasks and I don't want to put a hard @row number in there that would need to be maintained when new tasks are added. Same for automatic numbers in a RowID column. I was also doing…
-
Sheet Summary formula to included newly added rows
Hi, I created my sheet with some formulas at the top before I created Sheet Summary. Each day when new rows are added I am having to change the last number eg. 3861 to 3962. Is there a way to change the formula so the new rows are always included in the formula ? Current Formula: =SUMIF(Status19:Status3861, "Sent to Summit…
