STATUS (multi select) | RETOUCHING STARTS (date) | RETOUCHING FINISHES (date) |
IN RETOUCHING | ||
DONE |
What formula or automation can I use so that when I change "STATUS" to "IN RETOUCHING" a date is populated in "RETOUCHING STARTS" and when i change the "STATUS" to "DONE" a date is populated in "RETOUCHING FINISHES?"
I can not use the last modified because I want the date to remain the same when I change the "STATUS" to "DONE."