Quote Originally Posted by rbpd5015 View Post
#1) in the result column there are formulas in the result columns for stage 2 3 and 4. This is good if there is a W in stage 1. However if there is a stage 1 loss, you move on to stage 2 and must then put a W or L. I cant do that because there is only a formula there and when I put a W or L there it copies over the formula.
Of course. You'll type over the formula, yes? That's the correct thing to do as you use the sheet

Still got the problem I listed as number 1. This is a show stopper as of now. If I cant write results in the column I can make it a win or loose. Now I know I can write over the formula, however then I need to go back and re add it each time I do this. Makes it very difficult.
Re-add it each time? What does that mean? You set up the sheet and then use it through the year. You won't "re-add" until next year, but you'll start with your template, right? You'll keep a clean, ready-to-start version for next time.

#2) When I go to each school and make them when their stage #1 game on sheet #1, it works correct on sheet2 by saying there are no future stage 2 games the rest of the year. However it still shows all of the schools stage 3 and stage 4 games even though they are N/A.
I don't follow that. Show me.