Forum Discussion
Expanding a formula as rows are added to a table.
Hi all, I am struggling to come to a solution for the following problem: I have a Microsoft Form outputting its responses into a table in Excel, all nice and normal. I have inserted a new Co...
I'd suggest to add to the table returned by Forms another table column(s) (to the right) with any formulas you need. If you use structured references, formulas will be automatically added to each new row, as for any other table,
You may add new table column as very first one, but in this case you most probably will lost formatting for the data returned by Forms.