0

I have a formula in List settings-> validation settings.

The formula validates correctly. The user message I entered does not display, it displays its own message below which is

Error: The validation formula has evaluated to an error.

How can I show my User message?

See a screenshot below:

screen shot

1
  • The output is: Error: The validation formula has evaluated to an error.
    – Tony
    Aug 10, 2020 at 4:10

1 Answer 1

0

I can reproduce this issue in my environment. I haven’t found other formulas that block the custom user message but at least DATEDIF function is doing that.

You can switch to another formula like

[Original planned end date]>=[Actual start date]

or

[Original planned end date]-[Actual start date]>=0

It functions the same in this scenario.

enter image description here

6
  • Yes have changed the formula slightly and boom it works, message appears. Thank you.
    – Tony
    Aug 11, 2020 at 9:12
  • For the message 'End date must be greater than start date' this appears at the top of my form. Can the message be moved to the field which has the validation?
    – Tony
    Aug 11, 2020 at 23:32
  • @Tony I'm afraid not. That is the default behavior for list validation, and it cannot be modified. Aug 12, 2020 at 1:22
  • @Tony Is there anything more we can help you with? Would you please give it a vote or accept it as answer if you find the reply helpful? Aug 13, 2020 at 1:26
  • Ok done have marked as complete. Thank you
    – Tony
    Aug 13, 2020 at 6:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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