column validation with username and date

Question

hi guys
i need to validate the following
a value in the date column cannot be set before todays date for all users but one user only can enter a date in the past.
i tried this but did not work

=IF([Modified By]="Last, First",TRUE,IF([Back to Production on]>=TODAY(),TRUE,FALSE))

Answer 1

Hi @Egycruiser ,

Person or group colum is a complex column. We are not able to use person or group fields in SharePoint Formula. As you can see "Created By", "Modified By" and "Checked Out To" columns are missing in the "Insert Column" list on the Validation Settings page.

Therefore we can't use properties like loginname/displayname/email.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

did you try to use [Me] keyword for getting name of current user?