I am trying to capture a timestamp for when a spreadsheet is first edited, and ONLY keep that first timestamp. However, NOW() updates each time a spreadsheet is edited. I found a working formula ...
I have a column in my Google Docs spreadsheet which contains either "OK" or "NOK" (acceptance testing). How can I calculate the percentage for how often "OK" appears compared to "NOK".
I am trying to apply two filter functions in Google Docs. Column (A) contains new data Column (B) contains filter data, i.e. cells with text that should not be included in column C Column (C) is the ...