+2
| 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."
Best answer by TheTimeSavingCo
Try:
1. Create a formula field with `NOW()`
2. Create an automation that'll trigger when the Status is updated
3. In that automation, give it two conditionals, one that matches when "Status" = "IN RETOUCHING", and another when "Status" = "DONE"
4. Set up "Update record" actions in those two conditions to paste value from the formula field from step 1 into either "RETOUCHING STARTS" or "RETOUCHING ENDS"
+31Try:
1. Create a formula field with `NOW()`
2. Create an automation that'll trigger when the Status is updated
3. In that automation, give it two conditionals, one that matches when "Status" = "IN RETOUCHING", and another when "Status" = "DONE"
4. Set up "Update record" actions in those two conditions to paste value from the formula field from step 1 into either "RETOUCHING STARTS" or "RETOUCHING ENDS"
+2Try:
1. Create a formula field with `NOW()`
2. Create an automation that'll trigger when the Status is updated
3. In that automation, give it two conditionals, one that matches when "Status" = "IN RETOUCHING", and another when "Status" = "DONE"
4. Set up "Update record" actions in those two conditions to paste value from the formula field from step 1 into either "RETOUCHING STARTS" or "RETOUCHING ENDS"
Thank you!!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.