Hello,
I am trying to create a custom field that will display the date of the most recent change in Project status. I tried this formula but received syntax error.
MAX ((CASE WHEN ({systemnotes.field} IN ('Status')) THEN ({systemnotes.date})) ELSE ' ' END
Any ideas for other formula I can test? Thank you!