I am having a slow day, brain wise today.
I need to have a formula for a RYG column, that looks at two check box columns. First checkbox will change the RYG ball from Red when not checked to Yellow when checked. Then i have a second check box column for another department to change the SAME RYG ball column to GREEN when complete..
I got the first one set up, but i am not familiar with having an AND IF. Here is what i have
=IF([Sample Pulled]78 = 1, "Yellow", IF([Sample Pulled]78 = 0, "Red", (this first part works)
IF([Sample Complete]78 = 1 AND IF([Sampled Pulled]78 =1, "Green")))) (this is where i get stuck.
Thanks in advance.
Louise