I want to add these validations to my list:-
- if the status= "Invoiced", then user must enter a value inside the "Customer Invoice Date".
- if the status = "Paid", then the user must enter a value inside the "Customer Paid Date"
now i tried addign these formulas inside my list validation:
=IF(Status="Invoiced",IF([Customer Invoiced Date]<>"",TRUE,FALSE),TRUE) =IF(Status="Paid",IF([Customer Paid Date ]<>"",TRUE,FALSE),TRUE)
but i got an error:-
The formula refers to a column that does not exist. Check the formula for spelling mistakes or change the non-existing column to an existing column.
Now if i add each formula alone,they will work, but having them together will not work.. so is there a way i can add multiple validation for my list?