I am working on a calculated column that take value from other two different columns.

The formula is as this:

=IF([Detect-Rental/Lease]=1,IF([Detect-Rental/Lease Taxonomy]="Yes",TRUE,FALSE),TRUE)

As a result the column showing "No" and "Yes" in the list.

But the requirement desire is if it is FALSE it will flag an error. Very much appreciated if anyone can help with this.

  • 1
    You can add the same formula in list validation settings. May 18, 2020 at 4:27

2 Answers 2


You can add the same formula in list validation settings to show an error and don't allow users to save the form:

Follow below steps:

  1. Go to You SharePoint list.
  2. Then go to List settings.
  3. Click on Validation settings.
  4. Add same formula in Formula section.
  5. Then add suitable error message according to your requirement in User Message section.
  6. Click Save.

Official Documentation:

Edit list settings in SharePoint Online - Check Validation settings under General Settings.


Calculated Column is used to set value for the current column based on other columns' values of the same list/library, not for validation.

If you want to valid two columns of a list, you can use list Validation settings.

A blog about the validation setting for your reference.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.