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.