Skip to content

Instantly share code, notes, and snippets.

@smcllns

smcllns/IFTTT Drive Spreadsheet hack

Created March 30, 2017 05:29
Show Gist options
  • Save smcllns/30118cf547a531c9f097e45a0f83e690 to your computer and use it in GitHub Desktop.
Save smcllns/30118cf547a531c9f097e45a0f83e690 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
IFTTT Drive Spreadsheet hack
// if ( ( timestamp - previous timestamp [in minutes] <= 1 ) AND ( category === previous category ) )
IF (
AND(
((((TO_DATE(INDEX(SPLIT("{{ClickedAt}}" ," at ", false),1,1) + INDEX(SPLIT( "{{ClickedAt}}" ," at ", false),1,2)) - TIME(8,0,0)))
- CELL("contents", indirect("A"&row()-1))
) * 24 * 60) <= 1
, CELL("contents", indirect("B"&row()-1)) = CELL("contents", indirect("B"&row())))
,"duplicate"
,"")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment