Formula to look as Multi cells to check a Box on Another Sheet.

Alex Klingbeil

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

AnthonyxXx

Hi,

My initial thought would to create a new column in your tracker and use countifs to count when an item number is complete, and then use either an IF formula to change the tick box or use the change cell automation that will change the tick cell when the new column changes to 1. (Once the formula has been created, you can hide the new column to keep the tracker cleaner).