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?

  • If the field is not updateable, then would the validation formula even matter on update? May 24, 2012 at 16:55

1 Answer 1


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

  • 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, 2012 at 19:02
  • modified answer to specify that validation must be moved to list level May 24, 2012 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, 2012 at 19:24
  • Did you see the comment about moving the formular from the column to the list? May 24, 2012 at 19:26
  • That worked!!! Thank you so much!!! Wish I can return the favor some time....Joe
    – Joe
    May 30, 2012 at 12:36

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.