Topics created by hjalteworm

I got daily counters working from flic to google sheets by keeping one sheet that adds a new row with the timestamp a flic button is pressed (via. IFTTT) and another sheet that counts the number of rows on the first sheet that match a given day.

Here's what the first sheet () looks like:

2022-03-21 at 8.49.47 PM.png

Here's what the second sheet looks like:

2022-03-21 at 8.49.34 PM.png

The formula I use in the second sheet is:

=COUNTIFS(Sheet1!A:A, ">="&A2, Sheet1!A:A, "<"&A3)