Skip to content

Check whether the billing address is ready for review

Create a Formula Check that passes only when Billing City, Billing State, and Billing Country are all populated. When a value is missing, the card tells the user which address part needs attention.

All three values are fields on the Account that is already open, so Verify with a formula is the simplest evaluation type. This is guidance rather than a Validation Rule because an incomplete billing address should not block every unrelated Account update.

  • Confirm the required address parts with the teams that use the address for tax or territory work.
  • In orgs with State and Country/Territory Picklists, decide whether the formula should use BillingStateCode and BillingCountryCode instead of the display fields.
  • Confirm that the people using the card can read all fields in the formula.
  • Save new configuration inactive and validate it before activation.

You can add this Check to an existing Account Check Set. To create one, open Setup → Custom Metadata Types → Record Health Check Set → Manage Records, select New, and enter:

Salesforce fieldValue
LabelAccount Data Quality
Record Health Check Set NameAccount_Data_Quality
ObjectAccount
Card TitleAccount Data Quality
Card SubtitleConfirm the billing address is complete for tax and territory review.
When Checks RunWhen the user clicks Run
Summary DisplayShow below checks
Found/Expected DisplayShow on demand
ActiveUnchecked until validation succeeds

Open Setup → Custom Metadata Types → Record Health Check → Manage Records, select New, and enter:

Salesforce fieldValue
LabelBilling Address Is Complete
Record Health Check NameBilling_Address_Is_Complete
Check SetAccount Data Quality, or your existing Account Check Set
Check TitleBilling address is complete
Evaluation TypeVerify with a formula
Pass ConditionAND(NOT(ISBLANK(BillingCity)), NOT(ISBLANK(BillingState)), NOT(ISBLANK(BillingCountry)))
Display: Found FormulaIF(ISBLANK(BillingCity), "City missing; ", "") & IF(ISBLANK(BillingState), "State missing; ", "") & IF(ISBLANK(BillingCountry), "Country missing", "")
Display: Expected Formula"City, State, and Country populated"
Formula Result TypeAutomatic
Failure SeverityCritical
Message When Failed{!record.Name fallback="This Account"} has an incomplete billing address.
Fix MessageAdd every billing-address value named in Found, then run the Check again.
Action LabelEdit billing address
Action URL/lightning/r/Account/{!record.Id}/edit
Evaluation Order40
ActiveUnchecked until validation succeeds

Add Street or Postal Code to both the pass formula and user guidance if your business requires them. The Found formula is display guidance; only the Pass Condition decides the health result.

  1. Run the configuration-validation Flow.
  2. Correct every error and review every warning.
  3. Set the Check and Check Set to Active only after validation succeeds.
  4. Add Record Health Check to the Account Lightning record page and select the Check Set.
  5. Assign Record Health Check Card User to the people testing the card.

Use sandbox Accounts that are safe to edit.

Billing CityBilling StateBilling CountryExpected result
PopulatedPopulatedPopulatedPass
BlankPopulatedPopulatedCritical; Found names City
PopulatedBlankBlankCritical; Found names State and Country

Repeat a failing case with the same field access intended users receive. An unreadable referenced field must produce Unable to Check, not a guessed pass or failure.

The card evaluates the formula and compares its result with the configured expected value.

Result detailMeaning
PASSThe formula result satisfies the configured comparison.
FAILThe formula result does not satisfy the comparison, and the card shows the configured guidance.
SKIPPEDThe Check does not apply or a configured prerequisite did not pass.
FoundThe evaluated formula result for the current record.
ExpectedThe configured fixed value or evaluated expected formula.
What you seeCheck this first
A complete address failsConfirm whether your org uses the Code fields for State and Country/Territory Picklists
Found does not name every missing partCopy the complete Display: Found Formula and verify its quotes
Unable to CheckConfirm Read access to every address field in the formula
The Check Set is missing in Lightning App BuilderConfirm Object is Account and both records are active