Apply the list validation to only certain content types

Question

I have the following formula inside the list validation:

=IF(Status="Invoiced",IF([Customer Invoiced Date]<>"",TRUE,FALSE),TRUE)=IF(Status="Commission Paid",IF([Commission Paid Date]<>"",TRUE,FALSE),TRUE)=IF(Status="Delivered",IF([Order Delivered Date]<>"",TRUE,FALSE),TRUE)

and I have 3 content types for the list:

1. Project
2. Sales
3. Task

Where I want to apply the formula only if content type != Task? Can anyone advice?

Answer 1

You cannot use the "Content Type" in list validation formulas.

So, there is no way to add the conditional formula based on the current content type selected on list form.

If you are using classic experience, you can override the PreSaveAction() function on list forms to validate the entered data before saving the data.

For more information on using PreSaveAction(), check this: Is there a way to add the Content Type title inside our custom list validation settings' Formual

Similar questions:

1. List Item Validation With The Content Type Field
2. Use "Content Type" in list or column validation

---

Update from comments:

If you want to disable the validation when ItemNumber column contains -Task-, use below formula:

=IF(ISERROR(FIND("-Task-", [ItemNumber])), <Your-Original-Formula>, TRUE)

The later validation in above formula will trigger when ItemNumber column does not contain -Task-.