Word template with formulas in a table

(0) Share

Report

Posted on by KDillon

I'd like to create a word template to use with a customized entity that takes information we have in fields in the entity and put it in a table that calculates the body of the table. The formula will essentially be =filed1/100*field2*field 3 where field1 would be column1, colum2 would be row 1 and field 3 would be a single variable that may change from entity to entity. If I do calculated fields in the entity we'd need 50 calculated fields - the tables are 5 rows by 5 columns and there are 2 of them.

I've tried using Ctrl F9 to get the { } and then entering the fields as rich text, which gets rid of any syntax errors, but the cells come back blank when I run the template.