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 381
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