Validation Settings - Not able to save validation

Question

Dear Team,

I am trying to add validation on one of my Microsoft list but it is showing below error:

Requirement:

If "Approval Date" column is blank then "ABC1"column should be blank. If "Approval Date" column is not blank then "ABC1"column should not be blank.

Thank You!

Answer 1

Hi Sukie,

I tried your method but it still gives an error.

Just to mention here that my "Approval Date" column is a calculated column.

I tried to mimic your formula on 2 new columns(Without any calculation) and the validation worked properly for me.

Any idea why this validation does not work for calculated column?

Answer 2

Hi Bavaliya,

Thank you for posting back again and sharing information again with us. We’re sorry the late reply due to the weekend.

According to your description, it seems that Approval date is calculated column, if so, we have also tested it on our side, we created a new SharePoint list which contains calculated column Approval Date and singe text column ABC1 and test, and we used the same formula above and we still cannot reproduce the same situation as yours, we didn’t encounter any error message.

So to do more tests on our side to check if we can reproduce the same situation, we want to confirm the information below:

1. Could you provide the screenshot of list on your side which contains Approval Date and ABC1 column?
2. Could you provide the screenshot of Approval Date column calculation formula? So we can use the same formula test again.

We appreciate your understanding!

Best Regards,

Sukie

Answer 3

Hi Sukie,

Please find attached screenshot of list which contains Approval date and ABC1

Also, check below for formula of "Approval Date" calculated column:

=IF(OR([Trial Team Action]="Approved by Trial Team",[Trial Team Action]="Rejected by Trial Team",[Trial Team Action]="Approval not Required"),NOW(),"")

Thanks.

Answer 4

Hi Bavaliya,

Thank you for posting back and sharing so detailed information with us.

We tested it again with the same column and same formulas you provided above, as shown below:

Then we used the validation settings again and we can reproduce the same situation as yours. As shown below:

We have also searched a lot and we may not find any related article mentioned it, and we also cannot find any article mentioned such limitation. Per my test, the simple formula works when using calculated column.

Given this situation, we do understand the inconvenience caused apologize for it. This issue may need to be checked from background. The best way to troubleshoot the issue is to report the issue to the related Team. We’d suggest you contact your office 365 administrator to go to Office 365 Admin Center-> Support-> New Service Request, the support engineers there have the correct escalation channel and this is the most efficient way to report such issue. You can refer to this article to check the way how to raise a ticket. Ways to contact support for business products - Admin Help.

Thank you for your understanding!

Best Regards,

Sukie