Date time challenge & Nested Ifs formula solved?

Hi,

Need some help with this If statement. Currently: IF({Payment}=“Outside Finance”,CREATED_TIME())
What I would like to do is " If ({Payment}=“Outside Finance”,Create-Time(), And if when {Payment} changed from “Outside Finance” to “something else”, leave the original time created.

Thanks for your help in advance!

This should be its own post.

Assuming your {Payment} field shows sequential steps in a process your formula could be IF(OR({Payment}='Outside Finance', {Payment}='whatever comes after outside finance',{Payment}='etc'),CREATED_TIME())

Unfortunately formulas don’t work that way. There’s no way to tell a formula to “freeze” on a certain value once a condition is met. It will always evaluate based on whatever triggers feed it, so if any related field changes, it’s gonna change.

If the suggestion from @Kamille_Parks won’t work, the only other way to do this is to tie in a service like Zapier or Integromat, and change {Outside Finance} from a formula to a date field, letting the integration service populate the field with the proper date based on the rules you set.

Thanks for your reply. I have found a work around where I changed the field to a multi-select and this will record the initial status and also what changes after, thanks!