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:
- Project
- Sales
- Task
Where I want to apply the formula only if content type != Task? Can anyone advice?
PreSaveAction()
function - check 1st link in my answer below.