-
COUNIFS formula when multiple contacts
I have a sheet with columns such as "Status of Request"(Dropdown list: New, In Design, Completed) and "Assigned Designer"(My assigned designer column allows multiple contacts). I want to count how many projects under the status "In Design" for Designer "Luis" do I have so I have the formula =COUNTIFS([Assigned…
-
Help with Networkdays formula
i have a vacation calendar sheet. I am using the networkdays formula to calculate vacation days =NETWORKDAYS([Start Date]10, [End Date]10). The problem is that if there is not a start date and and end date entered into the cell it comes back with an "invalid data type." I am also using a formula to calculate remaining…
-
NEW Contains formula
I am trying to use the contains formula within a SUMIF (see below). This does not seem to work and I can not figure out why. It seems as though all the examples that are provided, CONTAIN is only used within IF formulas. Is this the case? My formula: =SUMIFS({Employee Tasks Range 1}, {Employee Tasks Range 2},…
-
Link to another sheet and add additional days
Hi there, I am trying to link to a master schedule but adding some additional days to define my drop dates. Please help. Thanks.
-
Date rollback
Hi All I'm having difficulty with my date formula's. i have a few in a sheet that i'm using to display today's date and a range of important dates as well as auto adding figures =SUMIF({Tokoroa orders}, TODAY(0), ({Tokoroa Orders out Range 1})) and =TODAY() my issue is that unless i manually go into the formula page all…
-
Creating a Sum for Filtered Rows
I have a Sheet which contains a complete list of all invoices, which Customer they are for, the Invoice Total and an Invoice Paid column which would show the balance of the Invoice. I have created a number of Filters for all of my Customers, so that I can filter straight to one Customer and see their outstanding balance.…
-
How to exclude values from a COUNTIF expression
I'm writing a COUNTIF formula referencing a column with multiple values that works well, until I try to build an expression that says: I want you to count the values in this column as long as they are NOT "x" OR "y" OR "z". Can anyone help with the proper syntax? I've tried the following but it doesn't work: COUNTIF…
-
SUMIFS Cross Sheet Issue
Hello Everyone! I am needing help with the SUMIFS formula for cross sheet reference but when I enter multiple criteria, it returns a value of 0. What I am trying to accomplish is a sum for Sheet-2 based on multiple criteria from Sheet-1: Criteria from Sheet-1 * Job ID* 216116 * Cost Code ID* 7 * 15 * 16 Sum Range: Act.…
-
Harvey Progress Ball at Parent Level
I have set up a column ("Task Complete Score") for numbering (0-4) to show progress which I am using to automate a column ("Progress") showing Harvey balls. I’d like to add a Harvey Ball for the parent row using an easy average. At the parent level, I have added this formula AVG(CHILDREN()) to get the average "Task…
-
Formula for RYG symbols with dates and checkbox
I'm trying to combine two formulas to automate RYG symbols. The first, this one, works fine to automate the symbols to be either red or yellow. Row #1 in the screenshot. The purpose is to keep the symbol red if the date column is either blank or empty, and yellow if there is a date in the column. =IF(ISBLANK([Start…