-
HOW TO REMOVE #DIVIDE BY ZERO AND MAKE CELL BLANK
I am trying to average a customer feedback section of my sheet. But if the cells where the data to be averaged will come from, the result section shows #Divide by Zero. I use the formula =AVG([column1:column2]). What's the formula I need to use for this? I saw in the other community discussion that I can use IFERROR but I…
-
Forumla Help, Nested IFs
Hi, Looking to see if someone can help me with this formula. I would like it to follow the following logic: * If Task is checked as complete= "Green" * If Task is past complete by date and not checked as complete= "Red" * If Task is 3 days until complete by date and not checked as complete ="Yellow" Here is the what I have…
-
Problems figuring out nested-IF formula
I'm having difficulty figuring out what is wrong with my formula in attempting to use a nested-if formula to automate the RYG light in the "Status" column, depending on the "% Complete" column. Here is my formula: =IF([% Complete]3 < 0.7, "Red", IF(AND([% Complete]3 => 0.7, "Yellow, [% Complete]3 < 1.0, "Yellow", IF([%…
-
Latest Date in Column
I am getting an error with this formula: =MAX([Due Date]:[Due Date]) #Invalid Column Value....the column name is Due Date and the data is configured to take Date.. Thanks
-
Metric Sheet -Showing Trending
I set up a metric sheet that with CountIfs formulas to show Monthly Stats.. I just realized that when I change the reporting period on my source sheet , I will lose the value counted in the previous reporting period... Is there a way to lock the data values in the previous reporting periods... arggh
-
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…