Thank you for reading my post.
Hello, thanks for your help. I'm looking to ping device list and enter current timestamp in column E if column D cell = "Online" as well as update the timestamp in column B. If the cell in column D = "Offline" I would like column E to keep the timestamp from column B. Basically trying to keep track of whether a device is online or offline and the last time it was online. Any help would be great. Thanks Again.
See attached spreadsheet.
Thanks Again.
Kevin
Bookmarks