Help

Using an IF clause for only the first occurence

Topic Labels: Formulas
566 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Sharon_Renold
4 - Data Explorer
4 - Data Explorer

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

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.