Skip to main content

Discount Not Over Price

This list validation uses a SharePoint formula to require the discount to be no greater than the price. Applied as list validation, it compares the columns when the item is saved and blocks the entry if the rule is not met.
Built with
Features
Currency Column, List Validation
Category
Formulas

Want one like this?

Talk to Greg

How It Works

  • What it does: Compares Discount and Price and blocks the save if the Discount is larger than the Price.
  • If it passes: Discount is less than or equal to Price, so the item saves.
  • If it fails: SharePoint stops the save and shows your message, for example: Discount cannot be greater than the price.

Common Use Cases

  • Sanity-capping discounts
  • Preventing negative net prices
  • Pricing integrity
  • Clean quote data

Details

  • Formula Type: List Validation
  • Formula Category: Numbers & Money

Required Columns

Display nameColumn type
DiscountCurrency
PriceCurrency

Prerequisites

  1. Create the columns the formula reads: Discount and Price
  2. Add or edit a few items so there is data for the formula to work with

How to Apply the Formula

  1. Go to List settings (or Library settings), then Validation settings
  2. Paste the formula below, which compares the columns
  3. Add a user message explaining the rule
  4. Save. New or edited items must satisfy the rule

Formula

=[Discount]<=[Price]

Common Questions About Discount Not Over Price Formula

What does this formula do?

Sanity cap. It runs as list validation, comparing the columns when the item is saved.

Which columns do I need to set this up?

You need: Discount (Currency), Price (Currency). The formula reads these to produce its result.

Why use list validation instead of column validation?

List (or library) validation can compare several columns to each other in the same item, which column validation cannot do.

If LookBook 365 is code-free and out-of-the-box, why does this example use a formula?

A SharePoint formula is native, declarative configuration, not custom development. It only works with the item's own fields and simple logic - it cannot run scripts, reach external services, or change other data, and nothing is deployed to your tenant. It keeps working through Microsoft updates. If you would rather not set this up yourself, this is exactly the kind of thing I configure for clients.

Discount Not Over Price Formula Example
Discount Not Over Price Formula Example