Feb 15 2022 06:56 AM
I have a spill error, "we can't spill within a table". I am working with a new sheet and a form I have created. When I enter my data the first line comes out correctly. When I add a new set of data the #Spill error occurs with the above message. How do I fix this?
Feb 15 2022 07:44 AM
Feb 15 2022 07:53 AM
@BruceFin I suspect you are entering a formula with a dynamic array function inside a structured table.
What formula are you entering? Can you upload a screenshot showing the problem?
Feb 15 2022 08:59 AM
One of two lines of development may be appropriate.
The first is to leave the calculation within the last column of the Table but make sure that the structured references are to single cells by using the "@" notation.
The alternative is to move outside the table and create a dynamic array formula that references entire table columns.
Feb 16 2022 08:13 AM
Feb 16 2022 08:14 AM