Tagged Questions

1
vote
0answers
1k views

Change value in one cell through a formula in another cell

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 ...
2
votes
2answers
3k views

How can I calculate how often one string appears in a column compared to another string?

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".
0
votes
1answer
2k views

Applying two filter functions in Google Docs Spreadsheets

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 ...