Hello @Terrell Chong ,
Welcome to Q&A Forum!
Please follow the steps:
1.Create two Choice columns named [Reason for delay(require intervention)] and [Reason for delay(No require intervention)]. And they only have a "Yes" option.
2.Use the below List Validation Formula:
=AND(OR(AND([Reason for delay(require intervention)] = "Yes",ISBLANK([Reason for delay(No require intervention)])),AND([Reason for delay(No require intervention)] = "Yes",ISBLANK([Reason for delay(require intervention)]))),OR(AND(ISBLANK([Comments(intervention required)]),NOT(ISBLANK([Comments(intervention not required)]))),AND(NOT(ISBLANK([Comments(intervention required)])),ISBLANK([Comments(intervention not required)]))))
3.Here is my test:
Thanks,
Echo Du
=======================================
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.