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
Help Article Resources
Check out the Formula Handbook template!