-
SUMIFS function
I would like to the sum of one column based on a specific date range in another column. e.g Need to total costs for June 2018. I am using the following formula =SUMIFS(Cost3:Cost29,[End Date]3:[End Date]29,”>=01/06/2018″,[End Date]3:[End Date]29,”<=30/06/2017″) However it is coming back with an error #UNPARSEABLE.
-
count values where two columns match
i am trying to count the number of matching pairs of values in two columns. eg: Column A Column B 1910 760 1910 810 1910 810 1990 760 1990 760 the outcome of the above that i am looking for is as follows 1910 x 760 = 1 1910 x 810 = 2 1990 x 760 = 2 can someone please help me with a formula that will give me these count…
-
countif
Hello, I have a formula that I'm attempting to count the number of projects within the Task Name column that have "hot CX" as part of the name. Task name is customer- Hot CX My formula returns a 0 count. What changes do I need to make with my formula? =COUNTIF([Task Name]1:[Task Name]100, "Hot CX") Thanks!
-
Conditional formatting with heirarchy and card view
Hey All, I'm having difficulty getting my card view tabs to show a certain color based on percentage complete for the subtask. When I create the rule it either highlights all the subtasks based on the parent percentage complete, or does nothing at all. I am trying to have individual subtasks change color base on…
-
collect with conditional statement to return all values
I am attempting to use a collect with no criteria, that is it grabs everything and am having some problems. =JOIN(COLLECT(Return:Return, a:a, IF(ISBLANK(a10), true))) my desired behavior is that if cell A10 is blank, all of the values of Return (including where A is blank) are collected. This is part of a much larger…
-
Conditional formatting and uniquely identifying cells
Hi, I would like to only apply conditional formatting to cells that are percentages. My rules currently set any cells that are over 100% as red, and 100% or less as green. Due to the red rule formatting any cell over 1.01 a lot of my data is showing as red, wheras this really needs to be white, there is no cause to flag…
-
Is there a way to define "today's" health, based on today's date and corresponding "% completion" va
Hey everyone, I've got a set of data pulling in completion % by date, and want to give my team a quick snapshot of overall health of the project based on completion % for TODAY(). I have used the following formula, which works for giving RYG per day: =IF(AND(Date9 = TODAY(), Difference9 < 0.05), "Green", IF(AND(Date9 =…
-
Countifs formula error
within the same report as my list of projects I'm trying to return a count of projects that are due to start within the current week (day 0 - 7) from "today" then return a count of project for next week from (day 8 - 13) then week 3 (day 14 - 20). here's the formula I came up with but it's not working.…
-
f(x) & Edit Reference do not appear
The help documentation states the following about cell references: “You can edit the name, referenced cell range, and source sheet of the reference.” If using a long formula and selecting the cell containing the formula, the left-most portion of the formula is not visible on the display (i.e., f(x) = AND Edit Reference do…
-
Reporting Using Parent Child Relationships
Hello - I have created a report to display the current user's list of high level milestones. This list is supposed to display any milestone that is blank under parent child relationship. This ensures only high level tasks are displayed. Its seems to work fairly well, but I have encountered one issue. For one of my sheets…
