Validation formula for Sharepoint list with IF and AND condition
I am trying to create a validation formula using IF and AND. So if the Title column contains spaces between words and the Created date is equal to today then throw an error message. (so error only needs to show if both conditions are satisfied
So far tried these formulas but it didn’t work as intended
=AND(IF(ISERROR(FIND(” “, [Title])),TRUE), IF([Created]=TODAY(),TRUE))
=IF(FIND(” “, [Title]),TRUE, IF([Created]=TODAY(),TRUE),FALSE)
=IF(AND(FIND(” “, [Title]), [Created]=TODAY()), TRUE, FALSE)
Can you please help
I am trying to create a validation formula using IF and AND. So if the Title column contains spaces between words and the Created date is equal to today then throw an error message. (so error only needs to show if both conditions are satisfied So far tried these formulas but it didn’t work as intended =AND(IF(ISERROR(FIND(” “, [Title])),TRUE), IF([Created]=TODAY(),TRUE)) =IF(FIND(” “, [Title]),TRUE, IF([Created]=TODAY(),TRUE),FALSE) =IF(AND(FIND(” “, [Title]), [Created]=TODAY()), TRUE, FALSE) Can you please help Read More
