I am trying to perform a strange and complex data Validation on a doc. It
will be between three different sheets. What I need is depending on if a
column on the first sheet says "Complete" I need a warning to pop up, when on
the other two sheets which also have the same corresponding projects, when I
try to enter hours for that project that has "Complete" in the first page.
So I have three sheets with the same projects listed but the first page it a
total of hours and status (complete, in work, canceled) then the second sheet
has hours each week for each project, and finally the final sheet has team
members hours for each week and project they worked on. So for the second
page I need an error to pop up when I try to enter hours for this week on a
completed project and for sheet three I need and error to pop up when I type
in the project code of a completed project.