Would like to auto populate records based off multiple conditions. I would like all records to populate in 3 columns (City/Contact/Notes) in "Calc" sheet as if it were a VLOOKUP and return all/multiple values based off Activity. Activity is in "Overview" tab.
Second part is to calculate "% Charge" based off Role in "Calc" sheet C2. if manager, split 100% by count of cities returned in lookup. If Engineer/Lead, default to 100% for field "% Charge". Time to charge is total minutes converted from hours in "Calc" b2 / 60 minutes.