I'm using the following formula to prevent users from entering spaces on the article name field.
The problem is the users have already entered data in this field prior to adding validation formula so the business owners want the validation formula to be implemented on new items only.
I know that I move my formula to the list validation settings however I'm having trouble combining 2 formulas. Below is my latest attempt
=IF(Created = "",ISERROR(FIND(" ",ArticleName)),TRUE)
So what I thought I was doing is if
Created == Null then perform the formula validation otherwise return a value of true.
So basically I want to perform my space check validation on new items only. Is there a way I can do that?