I am looking for a way for a column to be a ref in one situation and auto-complete in another situation. I have employees that belong to companies. When an employee gets a Merit increase, I want the “New” information to be filled in, but when an employee gets a reclassification, I want the same “New” fields to be editable. I have tried a ref field with an initial value of a lookup to the “Current” info (i.e. Company name), but then I can’t edit the field. I think what I am looking for is an if statement that sets the value to be a ref or auto filled in. I hope that makes sense?
Thanks in advance.