# Simple formulas in Layout tables **URL:** \ **Category:** Pro\ **Created:** [May 11, 2020, 8:58pm UTC](https://forums.sketchup.com/t/simple-formulas-in-layout-tables/125115 "2020-05-11T20:58:34Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![betazero](https://avatars.discourse-cdn.com/v4/letter/b/b5e925/32.png) [@betazero](https://forums.sketchup.com/u/betazero)\ **Post date:** [May 11, 2020, 8:58pm UTC](https://forums.sketchup.com/t/simple-formulas-in-layout-tables/125115/1 "2020-05-11T20:58:34Z")
Are there no simple formulas in tables in Layout? I need to sum up a column and add a couple cells together. If this isn’t a feature it for sure should be. I just started trying to use Layout as an Autocad replacement and this would be a problem. Also, how can I get entity info into a table (if possible)? ---
**Author:** ![DaveR](https://sea2.discourse-cdn.com/sketchup/user_avatar/forums.sketchup.com/daver/32/7601_2.png) [@DaveR](https://forums.sketchup.com/u/DaveR)\ **Post date:** [May 11, 2020, 9:20pm UTC](https://forums.sketchup.com/t/simple-formulas-in-layout-tables/125115/2 "2020-05-11T21:20:01Z")
Probably better to create your table in a spreadsheet application and save it out as a .xlsx file that you can insert into LayOut. As far as Entity Info information into a table, you can use Generate Report to collect that information into a .csv file. ---
**Author:** ![betazero](https://avatars.discourse-cdn.com/v4/letter/b/b5e925/32.png) [@betazero](https://forums.sketchup.com/u/betazero)\ **Post date:** [May 12, 2020, 1:23pm UTC](https://forums.sketchup.com/t/simple-formulas-in-layout-tables/125115/3 "2020-05-12T13:23:33Z")
Ahh ok I will try the generate report. Would be cool if you could add Wires kinda like the labeling tool but a wire could grab info and then put it into a cell or a text object or whatever. That way it would be a live connection and then have some simple adding and functions added to tables. Guess I need to put in a feature request. I am too used to having live tables in Autocad for Area calcs. ---
**Author:** ![DaveR](https://sea2.discourse-cdn.com/sketchup/user_avatar/forums.sketchup.com/daver/32/7601_2.png) [@DaveR](https://forums.sketchup.com/u/DaveR)\ **Post date:** [May 12, 2020, 1:45pm UTC](https://forums.sketchup.com/t/simple-formulas-in-layout-tables/125115/4 "2020-05-12T13:45:20Z")
Maybe something along these lines? Both little tables are from the same .xlsx file ![Screenshot - 5_12_2020 , 8_41_39 AM](https://global.discourse-cdn.com/sketchup/original/3X/6/f/6f8cbbc6ab7557bb13fffd2374637401ae8d6233.png) Open the spreadsheet from LO and edit the values as needed. Save the changes and go back to LO. The tables will show the update. ![Screenshot - 5_12_2020 , 8_42_08 AM](https://global.discourse-cdn.com/sketchup/original/3X/0/b/0b6e403a9b4220fa505c2fdd7c6b7b8c2932d4c9.png) I tried to make an animated GIF but for whatever reason, as long as the screen capture was running, LayOut wouldn’t update immediately. ---
**Author:** ![betazero](https://avatars.discourse-cdn.com/v4/letter/b/b5e925/32.png) [@betazero](https://forums.sketchup.com/u/betazero)\ **Post date:** [May 12, 2020, 2:10pm UTC](https://forums.sketchup.com/t/simple-formulas-in-layout-tables/125115/5 "2020-05-12T14:10:50Z")
I don’t want to have to use xls because then it won’t be a live connection. What I mean is something like this. A wire that you start on one thing and import into another thing. ![Screen Shot 2020-05-12 at 10.08.28 AM](https://global.discourse-cdn.com/sketchup/original/3X/a/1/a1add401b0532665d0a1d571c6c4a3117efea0b6.jpeg) ---
**Author:** ![DaveR](https://sea2.discourse-cdn.com/sketchup/user_avatar/forums.sketchup.com/daver/32/7601_2.png) [@DaveR](https://forums.sketchup.com/u/DaveR)\ **Post date:** [May 12, 2020, 2:18pm UTC](https://forums.sketchup.com/t/simple-formulas-in-layout-tables/125115/6 "2020-05-12T14:18:12Z")
Unfortunately that’s not currently an option. You can update the SketchUp model and have that update the viewports in the LO file but for text like you’re referring to, you would need to export a report from SU and update the reference in LO. ---
**Author:** ![betazero](https://avatars.discourse-cdn.com/v4/letter/b/b5e925/32.png) [@betazero](https://forums.sketchup.com/u/betazero)\ **Post date:** [May 12, 2020, 2:56pm UTC](https://forums.sketchup.com/t/simple-formulas-in-layout-tables/125115/7 "2020-05-12T14:56:12Z")
Yea I figured. Ok thanks maybe some day in the future