# L@123’s Profile

points
1251

hi there,

I am trying to count all dates that are on time comparing my due date column and delivery date column...

tried countifs, but it wont let me compare the whole columns...

Thanks

=COUNTIFS({Main Deck Range 1}, "Body", {Main Deck Range 2}, [34 System - Unassigned]1, {Main Deck Range 4}, <>"", {Main Deck Range 8}, 1)

This formula doesn't seem to work Range 8 is the reference to the column that has the

I’m working on a project where I need to have to 2 conditions on 1 status indicator.

• 1 for tracking duration against today's date:

=IF(NETWORKDAY([Start Date]9 + 1, TODAY()) / Duration9 <= [% Complete]9, "Green", "Yellow")

• 2. Tracking if a task is not completed on time:

=IF(AND(TODAY() >= [End

Hi Guys!

I am working on the following Formula:

=IF(AND([Date Completed]1 < (TODAY(-3)), Cause1 = "", Correction1 = ""), "Overdue", "OK")

Goal: If the date in a date column [Date Completed] is more than 3 days ago, and the cells for the next two columns are empty - one or both - I want to remind

Hi! I am trying to reference another sheet in a SUMIF. But I get "#UNPARSEABLE"

I want to sum contribution \$ in Column 2 if the vendor name is 9X. This info is in Sheet2. I am referencing it in Sheet1

Here is the formula : =SUMIF({VEND},"=9X",[{DSU}])

I have tried the formula

Hi,

I have total of 1200 tasks and 3 Assignees and I need to count : ( I want to create a Mini Dashboard on the top of my Task Sheet)

1. Total Number of 'Completed' by All 3 Assignees,

2. Total Number of 'Completed' by each of my Assignees.

3. How many tasks have been selected 'completed' from my

Hello - I need some help with the children formula.  I am trying to reference another sheet and only pull info from the children of specific hierarchies.

The only way that I can do it, as of now and with my current skill set, is if I select all of the actual children.  I realize this will be out of

I'm having difficulty with a few formulas wherein I'm attempting to SUM and COUNT only the CHILD rows so as to not duplicate amounts or counts (ie. need to exclude the Parent Row).

The formula below works when the BOLD text is not inserted.

The issue is that the potential exists where the sum

I have a google form that updates the prices of materials. On google sheets to display the most updated price of the material I have a Newest Entry Column =MAXIFS(Timestamp:range, Material cell) then in the material price columns I have an Index/Match formula to display the most recent entry for

Can I revert to an older version of a sheet from last night?  In the history I don't see where someone sorted the rows, so I'm not sure what happened?  I thought there was a way to revert to a certain time of day?  I don't know anything about a back up so this information would be helpful too?