Forum Discussion
Need help with validation formula for document list in Sharepoint list
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 ...
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:
- ISNUMBER(FIND("-",Title)) checks if the dash "-" is found in the Title. If it is found, the formula returns TRUE.
- If the dash is not found, the formula then checks if the Created date is less than today using Created < TODAY(). If this condition is true, it returns TRUE; otherwise, it returns FALSE.