Input Validation using two columns

[Neeraj_Malik]

I have a table named PRICING that has three columns i.e CUSTOMER NAME, SKU, PRICE
I need to have validation to ensure that there is no duplicate entry added for same CUSTOMER NAME and same SKU

Request if someone can help with appropriate logic for achieving the above input validation

Regards,

[Steve · Accepted solution]

Use this as the Valid If expression for the Customer Name and/or SKU columns:

OR(
  ISBLANK([Customer Name]),
  ISBLANK([SKU]),
  ISBLANK(
    FILTER(
      "Pricing",
      AND(
        ([_ROWNUMBER] <> [_THISROW].[_ROWNUMBER]),
        ([Customer Name] = [_THISROW].[Customer Name]),
        ([SKU] = [_THISROW].[SKU])
      )
    )
  )
)

[The_Ravals]

Hi Steve,

Could you please help me out with the following?

Correct syntax for two Valid If conditions to validate correct input

I’ve used one Valid If condition in my App and it works fine. Now I need to add another Valid If condition that uses a calculated number from another sheet/table/cell. I know I’m supposed to use the AND in my validation condition, but I don’t know exactly how. BTW, I’m a non-technical newbie, so please bear with me, and make the answer simple to understand and implement! Many thanks!

Parag

[Steve]

help.appsheet.com

AND()

Are all true?

[Neeraj_Malik]

Thanks very much @Steve