1

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?

Improve this question

1 Answer 1

Reset to default
1

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.

Improve this answer
3
  • I don't see the validation settings link in the settings page. Is it possible that it's a permission issue?
    – Madara's Ghost
    May 13, 2013 at 7:16
  • Note that I'm running SharePoint 2007.
    – Madara's Ghost
    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 :)
    – Anders Aune
    May 13, 2013 at 7:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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