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

Improve this question
1
  • The output is: Error: The validation formula has evaluated to an error. Commented Aug 10, 2020 at 4:10

1 Answer 1

Reset to default
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

Improve this answer
6
  • Yes have changed the formula slightly and boom it works, message appears. Thank you. Commented 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? Commented Aug 11, 2020 at 23:32
  • @Tony I'm afraid not. That is the default behavior for list validation, and it cannot be modified. Commented 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? Commented Aug 13, 2020 at 1:26
  • Ok done have marked as complete. Thank you Commented 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.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.