S7 should be locked, i want it to pull the data from the other side.
Also, they wanted the drop down to pull from the other side but also have the option to change it if they need to - which is why there is a formula, i know it seems stupid but i didnt make the decision on that one.. .

Also, now we're putting in a formula where there will be something entered into T26 which is merged with U26 and V26 where it will mark that side and quote as complete, incomplete, no response or response pending. we would like the send proposal button to send when it either says complete, no response or quote pending.

How do I get that instead of checking that all the fields are complete?