SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

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.

share|improve this answer
I don't see the validation settings link in the settings page. Is it possible that it's a permission issue? – Madara Uchiha May 13 '13 at 7:16
Note that I'm running SharePoint 2007. – Madara Uchiha May 13 '13 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 :) – Anders Aune May 13 '13 at 7:44
Thanks anyway :) – Madara Uchiha May 13 '13 at 14:50

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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