(I meant to name this ticket Google Sheets Functions*)
I have linked a table to google sheets, and the table was created without any issues. However, I have two columns that are using functions, and there are just zeros in these columns instead of the numbers that should be displayed based on the formulas.
Does wpDataTables have functionality to show values in a cell when the linked google sheets is using a function in the cell?
Unfortunately our plugin does not support functions or formulas or any formatting in Spreadsheet files. As I workaround I can suggest you to use our formula columns, you can find more information about them in our documentation.
Hello,
(I meant to name this ticket Google Sheets Functions*)
I have linked a table to google sheets, and the table was created without any issues. However, I have two columns that are using functions, and there are just zeros in these columns instead of the numbers that should be displayed based on the formulas.
Does wpDataTables have functionality to show values in a cell when the linked google sheets is using a function in the cell?
Thank you!
HI jensenb1190,
Thank you for your purchase.
Unfortunately our plugin does not support functions or formulas or any formatting in Spreadsheet files.
As I workaround I can suggest you to use our formula columns, you can find more information about them in our documentation.
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