spread_cheats
@spread_cheats
A community that creates and shares vetted solutions to everyday business problems that work in #GoogleSheets. Join us on Slack: http://bit.ly/spread_cheats
قد يعجبك
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 929K posts
- 2. Virginia 486K posts
- 3. #DWTS 38.7K posts
- 4. Mamdani 1.18M posts
- 5. $TAPIR N/A
- 6. Texas 201K posts
- 7. Prop 50 159K posts
- 8. Sixers 12.5K posts
- 9. Bulls 33.8K posts
- 10. Cuomo 384K posts
- 11. TURN THE VOLUME UP 6,437 posts
- 12. #Election2025 15K posts
- 13. Jay Jones 92.1K posts
- 14. Maxey 7,724 posts
- 15. Embiid 5,956 posts
- 16. Eugene Debs 1,516 posts
- 17. Andy 63.8K posts
- 18. WOKE IS BACK 26.9K posts
- 19. Harden 8,922 posts
- 20. Josh Giddey 5,280 posts
Something went wrong.
Something went wrong.