I am creating a SmartSheet whose rows are filled with the submission of the form and I wanted to utilize the hidden feature of the form to autofill a field when the form is submitted. I wanted this field to hold a formula that would select a value from a dropdown menu upon submission of the form but every time I submit the form the formula is added to the cell with an apostrophe in front of, signaling that it is text rather than a formula. When I remove the apostrophe, the formula works exactly the way I want it to. Is there any way to override this? If not, does anyone have any suggestions as to what I can do to have this same effect in another way?
