3 requests, if possible with API / IFTTT:
-
Can you create an entry for “Any Device”?
This way as devices are found they are automatically added to the spreadsheet?
-
Can you please drop the 3 characters " at" from the timestamp so those cells are auto-prepped for formulas? (The 3 characters " at" makes the cell a text cell).
-
Is it possible that when a device goes Off, you can have IFTTT have column E print the average wattage during last use?
Lastly, this will be quite a busy IFTTT activity if someone could choose “Any”, and it’s understood a new Sheet will be created every 2,000 Rows.
… … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … V heart V