Home

Formula change value only once

UjjwalBhujel
New Contributor

Hi Friends,

 

table.JPG

I want the value of "Is Customer" column not change "email" column.

 

For instance, email column looks up in registration, and if that email exists in "registration" column, the value in "is customer" changes to "Yes". But once it changes to Yes I don't want to change it back to "No" even if the look up email is deleted.

 

E.g. The value for abc@gmail.com in "Email" should still be "Yes" even if the email's been deleted from "Registration" column.

 

I hope it makes sense.

1 Reply
I guess you'll have to convert the formula to a value once the customer registration has happened.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies