default formula in hidden field

Amy M. K.

I need to reference the content from one field in another field on the same row. I want the formula as the Default Value of a hidden field on a form. The formula I'm using is =[Team Member]@row. When a new form is submitted, the field with the formula shows a single quote mark at the beginning, and therefore it's not working.

=[Team Member]@row (default formula in the hidden field)

'=[Team Member]@row (what shows up in the field when the form is submitted)

Any thoughts on how to correct this? Thanks!

Monique Odom-Stearn

Hello @Amy M. K.,

Is there a specific reason you need this to be a hidden field on the form? If you simply need the information on the row, you can make it a column formula so that it will automatically populate after the form is submitted.

Monique Odom-Stearn

Hello @Amy M. K.,

Is there a specific reason you need this to be a hidden field on the form? If you simply need the information on the row, you can make it a column formula so that it will automatically populate after the form is submitted.

Amy M. K.

Gah! Totally forgot about column formulas. That worked. Clearly I need more coffee. You're my shero for today!!! Thank you.

Save Draft