2

I'm attempting something fairly simple but seem to be coming across a few issues.

I have a custom list containing 2 currency fields what I want to do is add validation to the second column so that it can't be greater than the first.

I have gone into the edit column page and attempted to add the formula however I am then presented with below message:

The formula cannot refer to another column. Check the formula for spelling mistakes or update the formula to reference only this column.

I'm not sure what's causing this but I know it'll be something obvious I'm just not seeing. Any help would be appreciated.

7

That is the correct error message.

If you want to validate between multiple columns, go to the list's property page and click Validation Settings.

=[Column 1] > [Column 2]

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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