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?

1 Answer 1


You can do that using the Validation Settings.

Go to List Settings -> Validation Settings and add a formula for this:


And add a User Message telling the user that Progress cannot be larger than the Amount or something.

  • I don't see the validation settings link in the settings page. Is it possible that it's a permission issue? Commented May 13, 2013 at 7:16
  • Note that I'm running SharePoint 2007. Commented May 13, 2013 at 7:19
  • aha, its not available in 2007 i'm afraid :\ Then you need to make something yourself using javascript, or maybe there are some other solutions out there. Haven't worked on 2007 solutions for sometime tbh :) Commented May 13, 2013 at 7:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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