I am having a really hard time envisioning what exactly is in R5:R29.So my data from B5:D29 and F5:H29 were filtered and vstavcked into table "summary of chores" (S5:U29). There is a column labeled R5:R29 which I want it to return whether it is from the Daily Chore or weekly chore chart.
Daily Chores | Weekly Chores | Activate on specific days | Summary of Chores | ||||||||||||||||
Area | Chore | Time | Area | Chore | Time | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Type | Area | Chore | Time | |||
Jbedroom | Make Bed | 8:00 AM | Pets | Empty/Fill Litter | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | Jbedroom | Make Bed | 8:00:00 AM | |||||
Pets | Fill Water Bowl | 8:10 AM | Bathroom | Clean Vanity | FALSE | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | Pets | Fill Water Bowl | 8:10:00 AM | |||||
Pets | Clean Litter | 8:20 AM | Bathroom | Clean Toilet | FALSE | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | Pets | Clean Litter | 8:20:00 AM | |||||
Pets | Feed Pets | 8:30 AM | Bathroom | Vacumm | FALSE | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | Pets | Feed Pets | 8:30:00 AM | |||||
Kitchen | Wipe counters | 8:45 AM | Bathroom | Swifter | FALSE | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | Kitchen | Wipe counters | 8:45:00 AM | |||||
Kitchen | Empty Diswaher | 9:00 AM | Laundry | Vacuum | FALSE | FALSE | TRUE | FALSE | FALSE | FALSE | FALSE | Kitchen | Empty Diswaher | 9:00:00 AM | |||||
Kitchen | Fill Diswasher | 9:00 AM | Laundry | Swifter | FALSE | FALSE | TRUE | FALSE | FALSE | FALSE | FALSE | Kitchen | Fill Diswasher | 9:00:00 AM | |||||
Office | Vacuum | FALSE | FALSE | FALSE | TRUE | FALSE | FALSE | FALSE | Pets | Empty/Fill Litter | 12:00:00 AM | ||||||||
Office | Swifter | FALSE | FALSE | FALSE | TRUE | FALSE | FALSE | FALSE | Bathroom | Clean Vanity | 12:00:00 AM | ||||||||
Jbedroom | Vacuum | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | TRUE | Bathroom | Clean Toilet | 12:00:00 AM | ||||||||
Jbedroom | Clear off dressers | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | TRUE | Bathroom | Vacumm | 12:00:00 AM | ||||||||
Living | Clean off Coffee Table | FALSE | FALSE | FALSE | FALSE | TRUE | FALSE | FALSE | Bathroom | Swifter | 12:00:00 AM | ||||||||
Living | Vacuum | FALSE | FALSE | FALSE | FALSE | TRUE | FALSE | FALSE | Laundry | Vacuum | 12:00:00 AM | ||||||||
Living | Swifter | FALSE | FALSE | FALSE | FALSE | TRUE | FALSE | FALSE | Laundry | Swifter | 12:00:00 AM | ||||||||
Living | Febreeze Couch | FALSE | FALSE | FALSE | FALSE | TRUE | FALSE | FALSE | Office | Vacuum | 12:00:00 AM | ||||||||
Kitchen | Vacuum | FALSE | FALSE | FALSE | FALSE | FALSE | TRUE | FALSE | Office | Swifter | 12:00:00 AM | ||||||||
Kitchen | Swifter | FALSE | FALSE | FALSE | FALSE | FALSE | TRUE | FALSE | Jbedroom | Vacuum | 12:00:00 AM | ||||||||
Kitchen | Take out Trash/Recycling | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | Jbedroom | Clear off dressers | 12:00:00 AM | ||||||||
FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | Living | Clean off Coffee Table | 12:00:00 AM | ||||||||||
FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | Living | Vacuum | 12:00:00 AM | ||||||||||
FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | Living | Swifter | 12:00:00 AM | ||||||||||
FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | Living | Febreeze Couch | 12:00:00 AM | ||||||||||
FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | Kitchen | Vacuum | 12:00:00 AM | ||||||||||
FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | Kitchen | Swifter | 12:00:00 AM | ||||||||||
FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | Kitchen | Take out Trash/Recycling | 12:00:00 AM | ||||||||||
Daily Chores | Weekly Chores | Activate on specific days | Summary of Chores | ||||||||||||||||
Area | Chore | Time | Area | Chore | Time | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Type | Area | Chore | Time | |||
Jbedroom | Make Bed | 8:00 AM | Pets | Empty/Fill Litter | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | #SPILL! | Jbedroom | Make Bed | 8:00:00 AM | ||||
Pets | Fill Water Bowl | 8:10 AM | Bathroom | Clean Vanity | FALSE | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | Pets | Fill Water Bowl | 8:10:00 AM | |||||
Pets | Clean Litter | 8:20 AM | Bathroom | Clean Toilet | FALSE | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | Pets | Clean Litter | 8:20:00 AM | |||||
Pets | Feed Pets | 8:30 AM | Bathroom | Vacumm | FALSE | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | Pets | Feed Pets | 8:30:00 AM | |||||
Kitchen | Wipe counters | 8:45 AM | Bathroom | Swifter | FALSE | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | Kitchen | Wipe counters | 8:45:00 AM | |||||
Kitchen | Empty Diswaher | 9:00 AM | Laundry | Vacuum | FALSE | FALSE | TRUE | FALSE | FALSE | FALSE | FALSE | Kitchen | Empty Diswaher | 9:00:00 AM | |||||
Kitchen | Fill Diswasher | 9:00 AM | Laundry | Swifter | FALSE | FALSE | TRUE | FALSE | FALSE | FALSE | FALSE | Kitchen | Fill Diswasher | 9:00:00 AM | |||||
Office | Vacuum | FALSE | FALSE | FALSE | TRUE | FALSE | FALSE | FALSE | Pets | Empty/Fill Litter | 12:00:00 AM | ||||||||
Office | Swifter | FALSE | FALSE | FALSE | TRUE | FALSE | FALSE | FALSE | Bathroom | Clean Vanity | 12:00:00 AM | ||||||||
Jbedroom | Vacuum | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | TRUE | Bathroom | Clean Toilet | 12:00:00 AM | ||||||||
Jbedroom | Clear off dressers | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | TRUE | Bathroom | Vacumm | 12:00:00 AM | ||||||||
Living | Clean off Coffee Table | FALSE | FALSE | FALSE | FALSE | TRUE | FALSE | FALSE | Bathroom | Swifter | 12:00:00 AM | ||||||||
Living | Vacuum | FALSE | FALSE | FALSE | FALSE | TRUE | FALSE | FALSE | Laundry | Vacuum | 12:00:00 AM | ||||||||
Living | Swifter | FALSE | FALSE | FALSE | FALSE | TRUE | FALSE | FALSE | Laundry | Swifter | 12:00:00 AM | ||||||||
Living | Febreeze Couch | FALSE | FALSE | FALSE | FALSE | TRUE | FALSE | FALSE | Office | Vacuum | 12:00:00 AM | ||||||||
Kitchen | Vacuum | FALSE | FALSE | FALSE | FALSE | FALSE | TRUE | FALSE | Office | Swifter | 12:00:00 AM | ||||||||
Kitchen | Swifter | FALSE | FALSE | FALSE | FALSE | FALSE | TRUE | FALSE | Jbedroom | Vacuum | 12:00:00 AM | ||||||||
Kitchen | Take out Trash/Recycling | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | Jbedroom | Clear off dressers | 12:00:00 AM | ||||||||
FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | Living | Clean off Coffee Table | 12:00:00 AM | ||||||||||
FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | Living | Vacuum | 12:00:00 AM | ||||||||||
FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | Living | Swifter | 12:00:00 AM | ||||||||||
FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | Living | Febreeze Couch | 12:00:00 AM | ||||||||||
FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | Kitchen | Vacuum | 12:00:00 AM | ||||||||||
FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | Kitchen | Swifter | 12:00:00 AM | ||||||||||
FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | Kitchen | Take out Trash/Recycling | 12:00:00 AM |