If in a list of names if anyone has Yes next to their name in Column B then all of Column C must say "true". See Example below:
Column A Column B Column C
Drew No True
Drew Yes True
Drew No True
Drew No False
Bill No False
Bill No False
Bill No False
Adam No False
Adam No False
Adam No False
Bookmarks