Column formula do not appear in form



Hope you all are good in this crazy time.

I'm really new in smartsheet and maybe what I'm trying to do is not viable, so I'll try to explain myself as details as possible:

I want to create a form with some fields "auto-fillable" based on a cross-reference VLOOKUP formula.

I have a main sheet and there is a column called Site ID (dropdown single select) and base on this ID I use a VLOOKUP formula to determine the country associate with it doing a cross-reference with other sheet.

This proccess works well. But when I generate the form, the Country column don't show up and neither Site ID-name which have a similar format. I want this fields to be visible in the form to give the user a "hint" that the code select is the right choice, is this posible?.

Thanks in advance :)


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!