Unfortunately importing doesn't bring any of the content over in its entirety. There are lots of missing fields and its spread out everywhere. I think my sheet is too complicated.
The documentation mostly revolves around columns and not so much cells and rows.
Can I do math between cells? E.I.
FromSheetOne
A4+D30=somthing
but I'll need to carry the answer to another sheet and do more math
FromSheetTwo
somthing+B12+P8=new
I don't want to add the entire Column, I want to do math for specific cells
Thanks in advanced. :)
MikeL
HI Mike,
Thank you for your inquire.
You can take a look at our documentation about creating the tables from google spreadsheet.
There you will see the link to the tutorial to use the IMPORTRANGE and probably achieve your goal that you mentioned below.
You can test that on our sandbox site
http://sandbox.wpdatatables.com/
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi Bodan, thanks for getting back to me.
Unfortunately importing doesn't bring any of the content over in its entirety. There are lots of missing fields and its spread out everywhere. I think my sheet is too complicated.
The documentation mostly revolves around columns and not so much cells and rows.
I'll keep testing, maybe I'll find a solution. :)
Thanks again,
MikeL