Column formula do not appear in form

04/22/21
Accepted

Hello,

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 :)

Popular Tags:

Best Answer

  • Neil WatsonNeil Watson ✭✭✭✭✭
    Accepted Answer

    Hi, the only information the form has is the column names and properties. If any of the columns are formula driven then they cannot be used in the form.

Answers

  • Neil WatsonNeil Watson ✭✭✭✭✭
    Accepted Answer

    Hi, the only information the form has is the column names and properties. If any of the columns are formula driven then they cannot be used in the form.

Sign In or Register to comment.