Displaying a formula column in a form


Hi all

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!