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.

Using an IF clause for only the first occurence

Topic Labels: Formulas
133 1
Showing results for 
Search instead for 
Did you mean: 

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!

1 Reply 1

Formulas always recalculate.

Instead you can use an automation to move the value to an editable field the first time based on conditions.