Snipt.net is closing on December 31st, 2016

For more information, please visit this blog post.

snipt

Ctrl+h for KB shortcuts

Text only

Google Sheets Inline Array in formula

1
2
3
4
5
6
7
8
Use curly brackets with each value separated by commas.

{4,18,22,9,2,4,99,43}

{C2,D2,E2,F2,G2,H2,J2,K2,L2,M2,N2,O2}

Example of using in formula.
=SPARKLINE({C2,D2,E2,F2,G2,H2,J2,K2,L2,M2,N2,O2})
https://snipt.net/embed/644d801a8ab6260b150f20ee96e35cc5/
https://snipt.net/raw/644d801a8ab6260b150f20ee96e35cc5/
644d801a8ab6260b150f20ee96e35cc5
text
Text only
8
2016-12-10T07:42:34
True
False
False
Dec 08, 2014 at 05:16 PM
/api/public/snipt/137559/
google-sheets-inline-array-in-formula-b86cfa5c
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a> <a href="#L-2">2</a> <a href="#L-3">3</a> <a href="#L-4">4</a> <a href="#L-5">5</a> <a href="#L-6">6</a> <a href="#L-7">7</a> <a href="#L-8">8</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a>Use curly brackets with each value separated by commas. </span><span id="L-2"><a name="L-2"></a> </span><span id="L-3"><a name="L-3"></a>{4,18,22,9,2,4,99,43} </span><span id="L-4"><a name="L-4"></a> </span><span id="L-5"><a name="L-5"></a>{C2,D2,E2,F2,G2,H2,J2,K2,L2,M2,N2,O2} </span><span id="L-6"><a name="L-6"></a> </span><span id="L-7"><a name="L-7"></a>Example of using in formula. </span><span id="L-8"><a name="L-8"></a>=SPARKLINE({C2,D2,E2,F2,G2,H2,J2,K2,L2,M2,N2,O2}) </span></pre></div> </td></tr></table>
"google sheets", array, google, sheets

Markdown

Unlock account use imap , signing into a new device or application.

Text Error "connect to Gmail: Can not authenticate to IMAP server: [ALERT] Please log in via your web browser: http://support.google.com/mail/accou"


Allow access to your Google account

URL https://accounts.google.com/b/0/DisplayUnlockCaptcha

https://snipt.net/embed/c40ea106ab9d8028bb6f725eea7f7c37/
https://snipt.net/raw/c40ea106ab9d8028bb6f725eea7f7c37/
c40ea106ab9d8028bb6f725eea7f7c37
markdown
Markdown
6
2016-12-04T06:45:51
True
False
True
Jul 15, 2014 at 10:43 PM
/api/public/snipt/135779/
unlock-account-use-imap-signing-into-a-new-device-or-application-70ed9dcb
<p>Text Error "connect to Gmail: Can not authenticate to IMAP server: [ALERT] Please log in via your web browser: http://support.google.com/mail/accou"</p> <hr /> <p>Allow access to your Google account</p> <p>URL <code>https://accounts.google.com/b/0/DisplayUnlockCaptcha</code></p>
google, imap

Text only

JSON from Google Docs spreadsheet

1
2
3
`https://spreadsheets.google.com/feeds/cells/{{key}}/{{sheet}}/public/basic?alt=json-in-script`

https://spreadsheets.google.com/feeds/cells/0Ar8Fw_oE33ewdEFmN0JqejNOWjB2T19IVm9vV0NWNnc/1/public/basic?alt=json-in-script
https://snipt.net/embed/45f2466beb783cd70a96ded4fc61222b/
https://snipt.net/raw/45f2466beb783cd70a96ded4fc61222b/
45f2466beb783cd70a96ded4fc61222b
text
Text only
3
2016-12-05T23:47:17
True
False
False
Jan 14, 2014 at 11:58 PM
/api/public/snipt/105948/
json-from-google-docs-spreadsheet
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a> <a href="#L-2">2</a> <a href="#L-3">3</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a>`https://spreadsheets.google.com/feeds/cells/{{key}}/{{sheet}}/public/basic?alt=json-in-script` </span><span id="L-2"><a name="L-2"></a> </span><span id="L-3"><a name="L-3"></a>https://spreadsheets.google.com/feeds/cells/0Ar8Fw_oE33ewdEFmN0JqejNOWjB2T19IVm9vV0NWNnc/1/public/basic?alt=json-in-script </span></pre></div> </td></tr></table>
docs, google
Copyrighted, illegal, or inappropriate content? Email [email protected].