Welcome to deBUG.to Community where you can ask questions and receive answers from Microsoft MVPs and other experts in our community.
2 like 0 dislike
in SharePoint Server by

I've used a SharePoint calculated colmn to validate the request in colmn Name (Validity Stauts ) to show the Expired & Valid requests, However, the calculated colmn is giving me the result very well , but actually I have also OOB workflow when request be created a workflow shall be started.

The requriment is to when approval status is still  "In Progress" i want to let the caclulated colmn shows "Pending Verficaiton", when the the request Approved or Rejected it might be shows either Valid Or Expired.

=IF(AND([Course1 Expiration Date]<=TODAY(),[Course2 Expiration Date]<=TODAY()),"Valid","Expired")

What Should I change in the above SharePoint Calculated Column Formula to use Nested-IF?

1 Answer

1 like 0 dislike
by 155 174 350

Try to use the below formula with Nested-IF in your SharePoint Calculated column formula

=IF([Approval Status]="In Progress","Pending Verification",IF(AND([Course1 Expiration Date]<=TODAY(),[Course2 Expiration Date]<=TODAY()),"Valid","Expired"))
If you don’t ask, the answer is always NO!