title: SharePoint 2013 Calculated Column- Evaluate 3 other columns and return non-null value
body: <p>I have three content types on my SharePoint list, each with a calculated value (a number between 0-3) representing the Health of the project for that project type (Health1 is a calculation specific to Project Type 1, Health2 is a calculation specific to Project Type 2, etc.). </p>
  
  <p>Therefore, depending on the Content Type of the list item, only one of these 3 columns will have a number value between 0-3 and the other 2 will always be null. </p>
  
  <p>I want to create a list-level shared calculated column called simply "Health. The formula for "Health" needs to evaluate Health1, Health2 and Health3 and return the number from whichever is not null. Is this possible?</p>