Can I default cell values to a formula in the form without getting a ' in front?
I have a form entry sheet where I have some columns hidden but defaulting to a formula. The goal is to have the columns populate with the results of the formulas without any updates required (like cutting and pasting the formula in the grid). It works but a ' is inserted so the cell does not calculate and requires someone to remove the '. Is there a way to eliminate the '?
Also, sometimes the new row is added about 6 rows down from my last row. How can I get it to always add to the next blank row?