I have a sharepoint list that needs to do some notifications and trying to figure out how best to do it.
The list will have a bunch of fields but lets say that field Color drives field Contact
part 1 of Question: Contact is a calculated field, how does the caluculation look for the following logic:
- if color=blue then contact=blow, joe
if color=red then contact=red, sally
if color=grean the contact=green, george
once if have the calculated filed right is there a way to notify that user that someone selected them?