I am working on SharePoint and need some help. So I create a tracking log where user will validate information.

For example, if the status is closed, they are required to enter the date and the description of the case. So far date is working fine but description is not working. I tried doing following with no luck.

=IF(Status="Closed",IF(description="",IF([Date Closed]>=TODAY(),TRUE,FALSE),TRUE))

Can someone help? Thank you so much.


Try this

    =IF([Status]="Closed",IF(ISBLANK([Description]),FALSE,IF([Date Close]>TODAY(),TRUE,FALSE)),TRUE)
  • Hi, it did not work for Description. Once they select closed and enter dates, user are not even required to put any Description. Any ideas on how to solve it? Thank you for your help. – Sanju Singh Aug 4 '16 at 16:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.