SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.
Sign up to join this community
I have a list with 3 columns. Title, amount and progress.
Amount and progress are both number types. Is it possible for the progress column's maximum value to be the value of the amount column of the same item?
If not, is there a way to achieve what I'm trying to do?
You can do that using the Validation Settings.
Go to List Settings -> Validation Settings and add a formula for this:
=progress<amount
And add a User Message telling the user that Progress cannot be larger than the Amount or something.
