Why does my simple formula work in Excel but not-work in SharePoint?
Why does this formula...
=IF([Request Type]="Review",(IF(ISBLANK([Request Date]),FALSE,TRUE)),TRUE)
...work in Excel but fail when used it in SharePoint?
The intent of this formula is the following...
If the field "Request Type" has the value "Review" and the field "Request Data" is blank then show FALSE, otherwise show TRUE.
SharePoint saves the formula, but when a list item is saved where the formula is implemented, (under List Settings, List Validation), SharePoint does not say anything other than "List data validation failed" and that is it.
(I should mention that, for some yet unknown reason, I do not have access to be able to lookup the CorrelationID on this machine, but that's another long and sad story.)
(I should mention that this list is a custom Content Type, so may be that matters?)
Can you help?