Relative Content

Tag Archive for spreadsheet

Lark sheet query formuala

I use query function in Larksuite sheet to filter some date value but it doesn’t work. I want to get data in range A4:B7 where A = ‘2024-09-16’ but it shows nothing. I change switch to > (Greater than) operator, it works. More details in attached photo. Could someone please help?

Complexity limits of solutions created in Google Spreadsheets

I am creating a solution where I essentially put all rules regarding communication with customers (including automatic invoicing, reminder emails, welcome emails, etc.) into a Google Sheets and use Ultradox to create emails and PDFs based upon Google Docs templates. For the three automatic emails I have currently implemented this is working out really well, the whole thing is very transparent to our organization since even non-technical people can inspect and correct the “Excel”-formulas.

Complexity limits of solutions created in Google Spreadsheets

I am creating a solution where I essentially put all rules regarding communication with customers (including automatic invoicing, reminder emails, welcome emails, etc.) into a Google Sheets and use Ultradox to create emails and PDFs based upon Google Docs templates. For the three automatic emails I have currently implemented this is working out really well, the whole thing is very transparent to our organization since even non-technical people can inspect and correct the “Excel”-formulas.

Behavior of GAS and functions when moving folders

TOP階層ー第2階層
Aフォルダーaフォルダ内にGASや関数を含んだスプシがある場合
Bフォルダーaフォルダ内を移動した場合に既に作成しているGASや関数などは、修正が必要になりますか?
ドキュメントIDなどが変わりますか?