I have a formula that refs an autonumber field, the result is fine but when I thereafter edit a record the autonumber part of my result changes to display "null". Any ideas??
if((Legacy_Project_Number == ""),"LP."+ Project_autonumber ,Legacy_Project_Number)