Google Sheets has a nice advantage over Excel – their pivot table automatically refresh, while Excel’s pivot tables rely on clicking a manual UI refresh button (or – if the right pivot setting is changed from its default state – by reopening the relevant file). But Google Sheets’ pivot tables do not get refreshed in […]
Author: Math Dev
I have this spreadsheet which contains the name of multple files in my google drive Column one contains the current names of the files and column two contains the new names i want to assign to each file Using google app script i could do this manually by copying the old names one after the […]
I’m trying to remove WhatsApp clutter from my private photos folder on OneDrive. I’m using OneDrive on Android and it seems it is being used as the backup target for WhatsApp and Viber. I really need a suggestion on how to remove the whole WhatsApp lot from OneDrive and stop syncing new ones. If there […]
I used this formula in google sheets =importxml("https://www.investing.com/equities/aboitiz-equity-balance-sheet","//tr") However, however it is a nested table, so the values are not formated pro Symbol Exchange Currency AEV Philippines PHP Delayed ABTZY OTC Markets USD Delayed Period Ending: 202030/09 202030/06 202031/03 201931/12 Total Current Assets 149486.88 157703.15 157060.05 124425.29 **" Cash and Short Term Investments 65403.14 75288.51 […]
can someone help me? I use the google sheets importHTML function to scrap data from the website, but the number of tables keeps changing. How to set it so that it gets the correct table every time?
Trying to combine two separate, working queries, so both can be used on a single sheet. The idea is a User selects Data for a Resource (sheet TAB), and then either: a Region (Column D) or a County (Column H). Both Region and County are Drop Down lists. These are the Queries that work separately: […]
I’m using Google Sheets to build a crop planning tool for farmers (kinda like a gantt chart). I need help quantifying the number of days within a given timeframe that no crops are planted in a bed. In the end, I want to be able to be able to reference a single bed by name […]
I’m using Google Sheets to build a crop planning tool for farmers (kinda like a gantt chart). I need help quantifying the number of days within a given timeframe that no crops are planted in a bed. In the end, I want to be able to be able to reference a single bed by name […]
I’m using Google Sheets to build a crop planning tool for farmers (kinda like a gantt chart). I need help quantifying the number of days within a given timeframe that no crops are planted in a bed. In the end, I want to be able to be able to reference a single bed by name […]
select * , RANK() OVER (ORDER BY CAST(batchid AS INT) DESC) AS RNK FROM {0}.tablename I am new to coding and would like to where "0" holding the database name is {0} is supposed to be in my code. In python it is always in the ".format(….)" but this is a sql code and part […]