No matter what I do the validation for these 3 formulas don't work
if planned end date is >= than today and completion status is smaller than 100% ask for validation
if planned end date is >= than today and the status is <> than completed then ask for validation
if the completion status is 100% and the status <> than completed ask for validation
MY INPUT:
1.=IF(AND([Planned End Date]>TODAY(),Completion=100),FALSE)
2.=IF([Calculated End Date]>=TODAY(),Status="Completed")
3.=IF(Completion=100,Status="Completed",TRUE)
Notes: Status is a column that allows for a dropdown. One option from the dropdown is "Completed"
:Completion is a column that allows for a number input between 1-100.


