spread_cheats

A community that creates and shares vetted solutions to everyday business problems that work in #GoogleSheets. Join us on Slack:

[spread_cheats @spread_cheats]

@schoraria911 cool! We've done some work here too.

[Ben Collins @benlcollins]

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? 🤔

[spread_cheats @spread_cheats]

@benlcollins Prefer MROUND

[spread_cheats @spread_cheats]

@mrbenjaminhoppe feel free to generalize;

the ego that some [insert expertise] have here on Twitter dot com is absolutely insane

[spread_cheats @spread_cheats]

@aTylerRobertson You’re welcome to join us on Slack as well

[spread_cheats @spread_cheats]

@melvinthomasdev 🎉

[spread_cheats @spread_cheats]

@alicekeeler @Google Hear you 😁

[spread_cheats @spread_cheats]

@alicekeeler @Google realizing we just responded to a tweet from July of *2017* 🙈

[spread_cheats @spread_cheats]

@edtech_ology @HonapReshma Very punny

[spread_cheats @spread_cheats]

@benlcollins @Bazzaruto A course on how to promote the immense success of your course about making courses, obviously.

[spread_cheats @spread_cheats]

Lovely work by @brucemcpherson

[Bruce McPherson 🇪🇺🇫🇷🏴󠁧󠁢󠁳󠁣󠁴󠁿 @brucemcpherson]

SQL for Google Apps Script – it’s here
https://t.co/bdccIM7Krn

#gde #googleappsscript #sheets

[Bruce McPherson 🇪🇺🇫🇷🏴󠁧󠁢󠁳󠁣󠁴󠁿 @brucemcpherson]

SQL for Google Apps Script – it’s here
https://t.co/bdccIM7Krn

#gde #googleappsscript #sheets

[spread_cheats @spread_cheats]

@jsvxc made my day, thanks Jake.

[Alice Keeler @alicekeeler]

Try this spreadsheet to tweet for a twitter chat.
https://t.co/VkN0LaeHQr Type questions into column B and click on blue link to tweet. #GoogleSheets #googleEDU #LearnLAP

[spread_cheats @spread_cheats]

@oihamza Consider suggesting a "Repeat Last Report" option once someone follows the same flow twice.

It's a super-user feature but folks may notice it.

[spread_cheats @spread_cheats]

It may be slightly easier to just have a function

=ROLLING_AVG(data _range, window_size)

[Ben Collins @benlcollins]

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)))

[spread_cheats @spread_cheats]

@dontmesswithjo Don't Cell yourself short; you're more than the SUM of your job titles. Onwards!

[spread_cheats @spread_cheats]

Don’t cell yourself short.

[Prof. Feynman @ProfFeynman]

Don’t use your energy to worry!

Use your energy to believe, to create, to learn, to think, and to grow. 🧠