Enable a formula to reference self or at least its own field

currently this appears to be not selectable.

It does wipe out existing data in the field. I thought OK in the else condition just return self, or the same column that it is calculating, but this cannot be selected, yikes!

In order to archive lookup or rollup data a formula can be used in a field which based on date copies the values to a numeric field. It is important that such a function retain existing data in the the field. Currently since on else clause erases existing data and there appears to be no way to reference the field we are defining there is not automated way to do this.

Please allow reference to self or the same field for this purpose.

Thank you, Any suggestions are most welcome.

I would also love this.

Use Case:

  • You have a row name, eg “Soccer”
  • There is another column called “Date”
  • If a date exists, then you would like to add Date before the Soccer field

Example:

IF({Date}, {Date} & " - " & {Self}, {Self})

I realise you can separate the fields and then combine then in a Name Formula column, but then you have to have “Soccer” shown twice in each view so that you can actually edit “Soccer”. Being able to reference Self, while keeping the field consolidated would be very fancy and make for a nicer workflow.