Update cell in a table from a sum in another table

Hi. Is there any way for a cell of a TABLE A , to be automatically updated by the summirized ammount of a column of a TABLE B?

Hey @Stelios_Belesis ,
welcome to the Coda Community :wave:t4: :slight_smile:

Yes, with a formula you can summarize the values of a column and display it in Table A. But the formula in Cell of Table A will be applied to the whole Column in Table A. So depending on how your data is structured, you will have the same result in every row in that column in Table A. You can make it dynamic though, by select a filter based on a value of a different Colum of Table A.

Changes in Table B will automatically updated in Table A.

=[Table B].Costs.Sum()  <- This will sum a column of Table B

Here an example:

Hope that helps!

1 Like

@Daniel_Stieber Thanks a lot :call_me_hand:

1 Like