So I have a date field that needs to be a future date when the item is created. The formula I have set up for that is:
This works well however I am running into an issue. If the department is updating a List item after the Future Date it will still provide an error. Is there a formula to use when the column validation can only be active when a new item is being created and not edited?