내가 좋아할 만한 콘텐츠
Of course, you can build the currency string with reference to values in cells instead of hard coding it, like this: =GOOGLEFINANCE("Currency:"&A2&B2) Amazing! Is there anything Google Sheets can't do? 🤔
Lovely work by @brucemcpherson
SQL for Google Apps Script – it’s here ramblings.mcpher.com/apps-script/sh… #gde #googleappsscript #sheets
![brucemcpherson's tweet card. While working on Sheets Workbook functions – converted to Apps Script I realized that I’d need to tackle the query language at some point, so I figured I may as well go the whole hog [...]](https://pbs.twimg.com/card_img/1983541830223372288/sgSIJn7G?format=png&name=orig)
SQL for Google Apps Script – it’s here ramblings.mcpher.com/apps-script/sh… #gde #googleappsscript #sheets
Try this spreadsheet to tweet for a twitter chat. alicekeeler.com/twitterchat Type questions into column B and click on blue link to tweet. #GoogleSheets #googleEDU #LearnLAP
It may be slightly easier to just have a function =ROLLING_AVG(data _range, window_size)
The double index formula can be used to create a rolling average, by wrapping this double index with a standard AVERAGE function: =AVERAGE(INDEX(A2:A,COUNTA(A2:A)-6):INDEX(A2:A,COUNTA(A2:A)))
Don’t cell yourself short.
Don’t use your energy to worry! Use your energy to believe, to create, to learn, to think, and to grow. 🧠
Want to pivot data by financial quarter in #googlesheets? Don't stress about a bunch of fragile formulas, use our Cheat. Copy our interactive tutorial w the code: 👉 sheets.guide/quarter/copy 👈 #fpanda
Can you copy? Then you can install Cheats. Interested in joining the community: bit.ly/spread_cheats #googlesheets #opensource #spreadcheats
We created sheets.guide as a tool to help people navigate the many resources connected to each Cheat Check it 👇🏽 #googlesheets #OpenSource
Understanding search intent + finding content formats based on page titles in the SERPs 🔍 A (very) simple #GoogleSheets template for calculating the most frequent keywords in page titles. sheetsformarketers.com/count-keywords…
vlookup index match ( •_•) (•_• ) ( ง )ง ୧( ୧ ) /︶\ /︶\
If you user Apps Script and you haven't used the Apps Script dashboard yet, what are you waiting for? 👀 See and search through all your script files at once ➕ Create new script files 🔍 View details about script files ⚠️ Monitor the usage and see any failures of scripts
2019: No one will ever use QR codes. 2020-1: This restaurant actually has a menu? Nice tip @benlcollins
Every time I discover new functionality in #GoogleSheets I'm blown away by how powerful and versatile it is. Did you know you can create QR codes in Google Sheets? 🤯 🤯 🤯 We call an API with the IMAGE function and it returns a QR code based on our data. It's pretty neat!
Possible the LAZIEST #GoogleSheets hack... Add this bookmark to Chrome: javascript:window.open('https://t.co/fGNdcMqMXn') Now you can quickly open new sheets (+ save yourself at least 1.7 seconds of your life!)
Finally got round to adding some new stuff. More coming soon! 👇👇👇
🚨 New #GoogleSheets templates alert. Added 2 new categories to the spreadsheet directory...
United States 트렌드
- 1. New York 1.3M posts
- 2. New York 1.3M posts
- 3. Virginia 553K posts
- 4. #RadioStatic 5,886 posts
- 5. #Talus_Labs 1,008 posts
- 6. Alastor 18.1K posts
- 7. Prop 50 194K posts
- 8. Van Jones 2,868 posts
- 9. #DWTS 41.7K posts
- 10. #XLOV_UXLXVE 10.7K posts
- 11. TURN THE VOLUME UP 26K posts
- 12. AND SO IT BEGINS 10.8K posts
- 13. #QuestPit 7,540 posts
- 14. Ty Lue 1,008 posts
- 15. Jay Jones 108K posts
- 16. Clippers 9,776 posts
- 17. Cyrene 119K posts
- 18. Harden 10.1K posts
- 19. Sanford N/A
- 20. WOKE IS BACK 42.6K posts
Something went wrong.
Something went wrong.