I'm trying to get this SharePoint list validation formula to work.
I ultimately want to make sure the date value in my [Date of Appointment] column is greater than the date value in my [Date Followed-Up] column, if [Date Followed-Up] is filled in.
Here's what I tried:
=IF(AND([Date Followed-Up]<>"", [Date of Appointment]>[Date Followed-Up]), [Date of Appointment], "Needs updating")
Any thoughts? Thanks in advance!