I am trying to write a formula for labor costs (which is the name of the column) which will add 33% to the data entered. I can get the formula to work in a separate cell but when I try to past formula in the column I want it I keep getting "#UNPARSEABLE". I do not understand what I am doing wrong.

Additionally I am also working on a summary report that will provide an overall look at Contract Value, Total Revenue and CM% for jobs in process but keep getting results that include ALL contract values even for jobs that are not in process.

Need some guidance please.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!