title: SharePoint Calculated column based on other List data
body: <p>Possible to set the value of a calcualted column to data from another list? Say I have a lookup column, and based on my selection, another column from that lookup list?</p>
  
  <p>Also, Does the calculated column offer String Contains or begins with operators?</p>
  
  <p>And, side question, Can either of the above be done inside workflow Alert email conditons?</p>
  
  <p>Thanks. </p>