i have one field in salesforce "Coordinator´s validation" which is a checkbox. want to create another formula field "Coordinator´s validation date" where it will automatically populate the date of when the checkbox "Coordinator´s validation" is checked. how will be the formula. because this formula will not work IF(Coordinator_s_validation__c, TODAY(), NULL). because every time when i am updating the record that date is populating. i want to do it in configuration only. can any one suggest please.
 

I want to populate the Systemdate(i.e Day date) in the current_Date_sys date field if my checkbox  sys_check is checked.

 

and if it's  unchecked then i  want to make the current_Date_sys field blank.

 

Can anyone guide me on this formula?