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!