Displaying a formula column in a form
I would like to be able to display a lookup column result in a form. The user does not need to select this particular field but when a dropdown is selected in another field, it will lookup a corresponding number if a different sheet and populate the grid behind the form. I just want to display that result on the form for the user to see the corresponding number to that project. I will then give an option of a free text field if the user wants to use a different number.
e.g. When the project name is selected from the "Project" field, the "Cost Centre Lookup" result will display on automatically on the form.
Grateful for any suggestions. Thanks 😁
Help Article Resources
Check out the Formula Handbook template!