Jake Knoth

1

Hey Community!

One of my first requests. I dug around and so far haven't found anything, but my apologies in advance if this has been addressed elsewhere.

My company has been bouncing off sheet limitations for a bit now, yet none of our sheets are anywhere near 10,000 rows (I separate into logical

2

Hi!

I have a tricky formula I'm trying to calculate, but with no success so far... 

 

I have to different sheets that I'm looking on. 

Sheet1: Planning and monitoring sheet

Sheet2: Work reports


The formula challenge:

In Sheet2 our guys at the field are reporting on different predetermined projects.

2

I have two formula questions.

 

1. I have Parent rows with a rollup formula created that takes the avg of the RYG balls of its childreen and creates a status =IF(COUNTIF(CHILDREN(), "Red") > 0, "Red", IF(COUNTIF(CHILDREN(), "Yellow") > 0, "Yellow", IF(COUNTIF(CHILDREN(), "Green") > 0, "Green",