How to use Vlookup or Index/Match to automatically mark a task complete in destination row
I have a task tracker in which things are marked "Complete" from a dropdown and then checked off. The checkbox has conditional formatting that puts a slash through the entire row.
Some of these tasks are delineated as "projects", but I've created an automation to copy a row if it is labeled a project, so that anything that is specifically a project gets copied over into a Projects Tracker.
The problem is that I'm unfamiliar with Vlookup or Index/Match, and I'd like the task to be marked complete and slashed through on the destination sheet when this is manually updated in the source sheet. Currently, we're automatically updating both sheets when completing a project, which is inefficient.
This is what the source sheet looks like:
The destination sheet looks similar but only copies over lines that we fill out as Project (PR) in the Task Category column.
I tried an autonumber column but can't get much further than this. Any help would be appreciated!
Help Article Resources
Check out the Formula Handbook template!