Pro exercise

First available contact number

Pick each customer's contact number from three columns in a stated order of preference: mobile, then landline, then work phone. Whitespace-only cells count as empty. This is COALESCE — and the order of its arguments is the business rule.

• coalesce
• missing values
• priority rules

Sign in with a Pro or Lifetime plan to open the rules, the dataset and the workspace.