appwiki:googledrive

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
appwiki:googledrive [2023/03/06 03:32] – [Customize Google Form] yingappwiki:googledrive [2024/03/02 15:52] (current) – [Google Sheet] ying
Line 10: Line 10:
   - go to and select the folder you want to be always availble offline   - go to and select the folder you want to be always availble offline
   - right click > offline access > available offline   - right click > offline access > available offline
 +
 +====== Google Sheet ======
 +
 +**case and solution**
 +
 +  * case: calculate sold sum of all the item with note "from showroom" <code>
 +| A: Date | B: Status (sold/bought) | C: Name | D: Price | E: Note |</code>
 +    * solution <code>=SUMIFS(D2:D, B2:B, "sold", E2:E, "from showroom")</code>
 +
 +
  
 ====== Google Form ====== ====== Google Form ======
  • appwiki/googledrive.1678073550.txt.gz
  • Last modified: 2023/03/06 03:32
  • by ying