Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Date Formula

Topic Labels: Automations Formulas
Solved
Jump to Solution
496 2
cancel
Showing results for 
Search instead for 
Did you mean: 
tpick
4 - Data Explorer
4 - Data Explorer

 

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."

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

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"

Screenshot 2024-05-29 at 7.05.11 PM.png

Screenshot 2024-05-29 at 7.05.04 PM.png

Link to base

See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

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"

Screenshot 2024-05-29 at 7.05.11 PM.png

Screenshot 2024-05-29 at 7.05.04 PM.png

Link to base

Thank you!!