In a nutshell, I have two columns; the standard
I'm using this formula
=IF([Status]="New","","[Modified]") in the ACTION_DATE column to populate it with the last modified date if the status of the ticket is not equal to New.
The problem: I have is the formula half works - It will read the status, but the valve it returns in the list is
Any assistance offered would be greatly appreciated :-)