Sum many columns in row

[Skip2MiLu]

Hi

I just wondering if there a way to make sum expression compact if I wanting to sum each column from 1 to 53 for each key in this row.

Just seems I need to use a long expression using the sum, select and thisrow functions and I wondering if I just better using and excel sum formula in the the table vs trying to make a large appsheet expression.

Any thoughts

[WillowMobileSys]

Sorry, no.  AppSheet is a row-based platform (as are 99% of the development platforms  out there).  they do not have any column related functions and there are no shortcut ways to sum across all those columns.

I would strongly encourage you to switch this to a row-based table and actually a Parent/Child table design - Parent for the Yearly details and Sum and Child for the Weekly details.  You will find it much easier to maintain and to later implement the Semi-Annual and Quarterly breakdowns that WILL inevitably follow.