I use google sheet tables in which I fill in multiple "databases". I use data from databases to structure them with a google sheet and use them for reports. The existing formula I use to get my data out is: = if ($ B $ 1 = "Payment"; query (D! $ A $ 2: $ T; "select I, A, D, K, L where C = '" & $ A $ 1 & "'and B =' Output invoice 'order by'" & $ F $ 1 & "'"; 0); query (D! $ A $ 2: $ T; "select I, A, D, K, L where C = '"& $ A $ 1 &"' and (B = 'Construction site - situation / invoice' or B = 'Invoice' or B = 'Offer / proforma invoice') order by '"& $ F $ 1 &"' "; 0)).
it needs to be refined to automatically summarize projects by summing up an individual project and providing data according to a formula. An example is in the task file. Eg. it is necessary to summarize the "Daruvarske toplice" project and the "Lipik specijalna bolnica" project. Picture "tablica e" is current state, and picture "tablica e new" is future state. Formula must be in quary form as current.
17 pekerja bebas membida secara purata €28 untuk pekerjaan ini
Hi there, I am expert in Web search, Research, Market Research, Lead Generation, Web Scraping and Data Entry. Lets have a quick chat on this project to clear further details.