In a nutshell, I have two columns; the standard [Modified] and [ACTION_DATE].

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 [Modified]

enter image description here

Any assistance offered would be greatly appreciated :-)

1 Answer 1


Remove "" before and after [modified] so you get


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.