Formula with editable End If option

[j.b_o]

Hello,

Formula are very powerful and make possible incredible things…

I am wondering about a case : the possibity to edit the content of a field if the formula doesn’t find result. Example :

If(
  thisRow.Collaborateur = thisRow.Equipe.[Team Leader],
  "Free to edit the content",
  thisRow.Equipe.[Team Leader].Todo
)

The first approach i see is to use multiple columns : one to edit, one with the formula. The drawback is that you get multiple useless field in the layout.

Does someone face to this case?
With clever idea do you find as workaround?

Thank you in advance for the help

[Piet_Strydom]

Hi,

This is the way that I do something similar:

I load the bank account information into a table, the Autopost rule kicks in. And where the autopostcolumn formula does not find a rule, I then add a manual Account as shown (or if I want to override the auto account).
The column for final account then follows this logic: If an entry in the manual account, use that entry, else take what is in the autopost account.

It’s just a ramble…
Rambling Pete

[j.b_o]

Thank you @Piet_Strydom .
It’s the way i was thinking. I will try this.