Is there a spreadsheet function (Google, Excel, Numbers, or otherwise) that can watch a row and update a cell with the current date when any cell in that row changes? If not for the entire row then ...
When I see that somebody has changed a document I am working on in Google Drive, I normally want to see where exactly the change happened. Using File > See Revision History... is not really helpful ...
So, basically, I've got this table: A2:A =MIN(ARRAYFORMULA(IF(ISBLANK($D2:$G2);$D$1:$G$1;Temp!$C$89))) B2:B =MAX(ARRAYFORMULA(IF(ISBLANK($D2:$G2);$D$1:$G$1;Temp!$C$89))) C2:C =SUM(D2:2) and ...