Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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
add comment

1 Answer

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.

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
add comment

Your Answer

 
discard

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.