Forum Discussion
Solved
Table not populating using VSTACK
I have multiple sheets and each sheet has a table in it. I am using VSTACK to populate a "Dashboard" sheet that combines all the tables. Every table is working, except for one. When I try to put this...
- I was able to fix the problem by re-creating the table. I found that the issue was with the formulas I was using to calculate dates (when I would copy and paste the content as plain text the VSTACK worked). So I recreated the table and reapplied the formulas for dates and it worked.
I do not know why the formulas in the first table were not working originally as they are the same ones used in the current table that is working.
I may need to see the sheet, but I'd start by isolating the problem table. What happens if you try to spill that table?
For example:
When I spill the table it still populates with a single zero
- If the range the table is looking at looks good (more than 1 cell), then I'd try converting the table to a range and then convert back to table.
- I have done this and it did not work.