Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.
Jun 07, 2022 08:56 AM
Hey there! I’m massively hitting a wall with something that might take a script?
I’m creating a Production Planner/Tracker for a YT Channel and want to have a formula that spits out the current date & time of when the {Production Status} is changed to “Post-Production” so that I have a {Post-Prod. Start Date}.
That worked fine with: IF({Project Status} = "Post-Production",LAST_MODIFIED_TIME(), BLANK())
The problem comes when I have to switch the {Production Status} to “On Hold” or “Complete”. It obviously removes the {Post Prod. Start Date} Value. And in the case of “On Hold” it will then go on to replace it with a new date and time if/when the project gets set back to “Post-Production”.
So my question I guess is, how do I get the formula to only run the first time around - or what other work-around is there?
I hope this makes sense :open_mouth:
Thanks in advance!
Sharon
Jun 07, 2022 09:16 AM
Formulas always recalculate.
Instead you can use an automation to move the value to an editable field the first time based on conditions.