looking for help. not even sure how to Word this. but i am looking for help on writing a formula that would check a box on another sheet if this form is filled out and a assigned work order #. so if someone was to say that Step 1 is Complete with this work order #. it would Check the Step 1 box that is in the tracker automatically.
Here is the Form that gets filled out
with this Form that get filled out it can Grow with Logic to hold information for up to 5 work orders.
when someone fills this out. i would like my Tracker that i put together check a box if they select complete. the Kicker is the Page the form goes to is very long.
what i am looking to do is having my Tracker
this is where i would need the Check box to Mark as "1" or True. if on the Form the Work Package# is the Same as the one in the Workpack Column. and the Form will Look to see if they Checked Step 1-4 and only if they check the Status as Complete i would check the box.
my Start.
=IF(MATCH(Workpack@row, {WP 1}, 0) = Workpack@row, IF({WP 1 Step} = "Step 1", IF({WP 1 Status} = "Complete", 1, 0)))
i am not even sure if this can even be done. just wanted to ask.
thank you for taking the time to read this Rambling Post
