Hey everyone!
With the Labour Day holidays coming up, we’d like to let you know about our upcoming working hours:
Thursday, May 1st: Our team will be off during Labour Day.
Friday, May 2nd: We'll also be off for an extended holiday break.
We’ll be back on Monday, May 5th, ready to respond to all messages received during this time.
In the meantime, if you need help, feel free to:
-
Use the support widget on the bottom right of our websites (Amelia and wpDataTables) — our AI-powered assistant is available 24/7 and can help with many common questions.
-
Visit our documentation, articles, or YouTube channels for quick answers and step-by-step guides.
https://www.youtube.com/@AmeliaWordPressBookingPlugin/videos
https://www.youtube.com/@wpDataTables/videos
Thank you for being so understanding, and we hope you enjoy the long weekend!
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ć
milos.jovanovic@tmsproducts.io
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