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