Sep 26 2024 01:18 PM
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))
Sep 27 2024 09:50 AM
@BhushanJ935
Made a slight adjustment to properly check the conditions. Here's a revised version of your formula:
=IF(ISNUMBER(FIND("-",Title)), TRUE, IF(Created < TODAY(), TRUE, FALSE))
This formula works as follows: