Validation Settings Question

Question

I am attempting to validate a column based on the contents of another column. In this case I have [Incremental Spend] and [Incremental Spending Reason]. If [Incremental Spend] is greater than $1, I would like [Incremental Spending Reason] a requirement.

Any suggestions?

Answer 1

If you are using SharePoint 2010 or above then you have list level validation in the list settings. Here you can create a formula which refers to multiple columns.

There is an example of the sort of thing you want to achieve on Gary Bushey's blog here