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.
In the screenshot I am sharing the first formula results in a "0" and the second and third formula result in "1/0/1900"
EllenC53715 Can you perhaps create two dummy files: One containing just two or three fake contacts and the range name I advised you to use. The other where you use that range name in a formula to retrieve the information from the first. Save and then upload these two files to a location which you can share with us.