Thursday 19 September 2013

How to check a list column value is null in calculated column

=IF(NOT(ISBLANK([Column1])), IF(NOT(ISBLANK([Column2])),
IF([Column1]<=[Column2], "Success", "Failure"),""), "")

No comments:

Post a Comment