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:
Here's what the second sheet looks like:
The formula I use in the second sheet is:
=COUNTIFS(Sheet1!A:A, ">="&A2, Sheet1!A:A, "<"&A3)
