I am building an inspection sheet and form where our operations team will be able to mark pass/fail through a checklist.
If something "fails", I want that specific row in the inspection sheet to be copied over to another project tracking sheet. These two sheets will necessitate different fields.
Upon the specified condition, how do I only have partial rows copied over to my project tracking sheet?