HI,
I have Lookup formula in my form.
It is working fine however the Output has the ID;# Column Value (Image Attached)
This is the formula that i have used.
lookup("Contract Type","ID",TypeofAgreement,"Contract") |
How can i get rid of the prefix text the "ID;#"
Thank you in advance
Venkat