What am I doing wrong with my formula

Kohl W

I am trying to add the original contract column and approved change order column to give the total to the corresponding row in the revised contract column as well as keep as total at the bottom as you can see with the original contract and approved change orders. Can someone tell me why it is coming up unparseable?

Paul Newcome

You don't need all of those backslashes. Just wrap each column name in square brackets.

Andrée Starå

https://community.smartsheet.com/discussion/109270/what-am-i-doing-wrong-with-my-formula

Hi,

I hope you're well and safe!

What are your column names? Looks strange with the backslashes. Are they part of the names? If yes, they should be surrounded by [ ] square brackets.

Was that the issue?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Paul Newcome

@Andrée Starå Column names are already in the post. The backslashes are not, but the column names do have square brackets in them.

Andrée Starå

https://community.smartsheet.com/discussion/comment/391907#Comment_391907

Haha! I missed the top part.

DKazatsky2

Hi @Kohl W ,

It looks like you are missing the first [ in your formula. Try this.

=SUM([\[$\] Original Contract]@row, [\[$\] Approved Change Orders]@row)

Hope this helps,

Dave