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

This formula works fine when adding a new list item:

=[Class Date]>=TODAY()+3

Basically ensuring the user selects a date greater than two days away from current date.

I don't want the formula to be in effect if the record is an UPDATE to an existing record.

So if someone comes back to this record after completing it correctly and saving it, but now wants to update a different field I don't want this field to be editable nor do I want the validation formula to be applied to the updating of the record.

Is this possible?

share|improve this question
    
If the field is not updateable, then would the validation formula even matter on update? –  Abe Miessler May 24 '12 at 16:55
add comment

1 Answer

Try the formular:

=OR([Class date]>=TODAY()+3,Created<TODAY())

Where the first formular could be specified as validation on the column, this needs to be at the list level:
enter image description here

share|improve this answer
    
I get this message with that: The formula cannot refer to another column. Check the formula for spelling mistakes or change the column to this column. –  Joe May 24 '12 at 19:02
    
modified answer to specify that validation must be moved to list level –  Per Jakobsen May 24 '12 at 19:12
    
This is the value of Created for one of the records in the list: Created at 4/6/2012 3:19 PM AND this is the value of [Class Date] for that same record: 4/2/2012 SO, could it be the difference in format that is causing this issue? I don't understand the error msg which I posted previously...appreciate the assistance!! –  Joe May 24 '12 at 19:24
    
Did you see the comment about moving the formular from the column to the list? –  Per Jakobsen May 24 '12 at 19:26
    
That worked!!! Thank you so much!!! Wish I can return the favor some time....Joe –  Joe May 30 '12 at 12:36
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.