I am trying to apply validation to document title column, we replacing spaces in title with dashes manually, Validation should fail if it cant find dash in title column, but only want to apply it to new items and not to existing items. So Title needs to contain “-” if thats true all good no need to check created date, But if dash is not found it should check wheter the Document [Created] date is less than today, if its less than today then all good, but if created date is equal to today then validation should fail.

This is the formula i have tried so far but it doesnt seem to work

=IF(FIND(“-“,Title),TRUE,IF(Created<TODAY(),TRUE,FALSE))

​I am trying to apply validation to document title column, we replacing spaces in title with dashes manually, Validation should fail if it cant find dash in title column, but only want to apply it to new items and not to existing items. So Title needs to contain “-” if thats true all good no need to check created date, But if dash is not found it should check wheter the Document [Created] date is less than today, if its less than today then all good, but if created date is equal to today then validation should fail. This is the formula i have tried so far but it doesnt seem to work =IF(FIND(“-“,Title),TRUE,IF(Created<TODAY(),TRUE,FALSE))  Read More

​