-
#DIVID BY ZERO
I have been using the following formulas to get averages, so far it has been working till now. I get #DIVID BY ZERO, where did I go wrong? =AVG([Approval Metric]650:[Approval Metric]789) =AVG([Response Metric]650:[Response Metric]789)
-
Flag Column
Hello! I'm trying to trigger the flag in the overdue column if we've missed the proposed response date. My formula is calculating, but it's not turning the flag on. What am I doing wrong? =IF([PROPOSED RESPONSE DATE]2 < TODAY(), "1")
-
Countifs error
Hello, I am trying to count the number of occurrences when column1 = value1 AND in the rows that have a check box in column2. Can anyone see why this formula is #Unparseable? When tested individually, the formulas work but together I get an error. =COUNTIFS([column 1]:[column 1], "value 1”, [column 2]:[column 2], "1")…
-
Count Children formula
I have this formula that is working properly except I need to adjust it. Basically what this formula is doing is counting the children rows if a specific date column has nothing (is blank). However, what I need to also adjust for is to have my formula return a "zero (0)" if the units have expired (captured in a helper…
-
How to emulate a pivot table
I have a sheet in excel that contains rows of dates (basically the header of a set of emails including received date). What I need to know is how many rows for each date. In excel I created a pivot table to count on the received date column. Is there some way to emulate this type of count in SS? I can just as easily put…
-
Auto fill from a another sheet
Is there a way to autofill from one sheet to another. Example: I have data on one sheet and I am creating a % on another sheet. So I am linking the cells and dividing by a number in my % sheet. Is there a way to "drag" the data from the original sheet, so that I dont have to link every single cell individually?
-
RYG and Gray!
Hey, I cant figure out how to add to this formula. I have this formula that someone shared from a seminar: =IF(AND([End Date]@row + 1 < TODAY(), [% Complete]5 <> 1), "Red", IF(AND([End Date]@row -2 < TODAY(), [% Complete]@row <> 1), "Yellow", "Green")) . This give me my r,y,g health in the right time frame i want. What I…
-
VLookup and non-match
Hello, I have a VlookUp question with 2 sheets. Sheet 1 has a simple table (see attachment) with Sizes and Hours. Sheet 2 - On another sheet, I want to executive a Vlookup and reference the table of Sizes and Hours from sheet 1. If I want to have a blank, I want to show a zero (0) value instead of "No Match." This also…
-
Returning date format to text in additional column
Hello, Is there a way to return a date formatted column to an additional text column using formulas? I'm looking to create a report. It's not letting me use the "date" formatted field. That field needs to remain in date format, so was looking to add an additional column so it will automatically populate the date into text…
-
How do I calculate hours in a given week for a specific task for a specific person
Hello there I have a sheet with the following columns: -[Date] Type: Date -[Name] Type: Contact List -[Professional Development Time] Type: Text/Number (# of hours the person spent on professional development) -[Project Related Time] Type: Text/Number (# of hours the person spent on projects) Here's a link:…