Apostrophe being inserted before Formula when using Smartsheet Forms

Hello, we have a Sheet setup with a Column which has the Formula =[Project]@row + " " + [Note]@row taking the info from the Project and Note columns. We also have a form for this sheet where you pick the Project and add a Note, what happens when we complete the form is a Leading Apostrophe is inserted in front of the formula so it shows up like below instead of taking the info from the two columns cells in that row? Is there a solution to this?

'=[Project]@row + " " + [Note]@row

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!