Hi @Alinea_Avi
That is not the way AppSheet works.
If you need to do so, I suggest you make a formula in another sheets through an IMPORTRANGE() or QUERY() or whatever fits your need, function, then a SUM().
I suggest:
={"Total col4";SUM(QUERY("sheetAndRangeWhereYourDataAre", col4))}