When the picklist value changes to new for the first, I want my date field to be updated for today's date. And this update should only happen once. What should I go for in this case?
- Formula field
- Process builder
Is this the correct formula? IF( AND( ISPICKVAL(STATUS, 'new') ), ISPICKVAL(PRIORVALUE(STATUS),"new") ), TODAY(), '' )