Set value of cell that contains an app formula to not change once entered?

Hello,
Was wondering if anyone can assist with this:

I have a column called [Tech Email] that uses an app formula USEREMAIL()

When I have another user edit a different column in that record, it changes the [Tech Email] column

How can I prevent the column [Tech Email] from changes once recorded?

I tried to use Editable_If formulas, but I get this response:

Column Name ‘Tech Email’ in Schema ‘Time Entries_Schema’ cannot use an EditableIf constraint if it has an App Formula. The EditableIf constraint will be ignored.

Solved Solved
0 3 382
1 ACCEPTED SOLUTION

Move the USEREMAIL() to Intial Value and put ISBLANK([_THIS]) in your Editable If

View solution in original post

3 REPLIES 3

Move the USEREMAIL() to Intial Value and put ISBLANK([_THIS]) in your Editable If

IT helped me too… Thanks

Genius, worked like a charm. Thanks!

Top Labels in this Space