I have a Google Spreadsheet with several boxes with the little orange triangle indicating a comment associated with that cell. Unfortunately, I haven't made any comments, so cannot delete these boxes. How do I go about clearing these cells without deleting everything and starting over?
Google Sheets – Managing Comments Effectively
google sheets
Related Solutions
This is exactly the job of the QUERY command:
=QUERY(Sheet1!D:F, "select D,E where F='Case'")
returns
Sinclair Complete
Davis Complete
It appears that the hours' field is required for time to be recognized as such. Enter 0:mm:ss.SSS (assuming decimal dot; could be a comma in your locale), for example 0:22:22.222
The default format for duration does not include the milliseconds' field, eg. use a custom one:
The first field should be "elapsed" to make the format a duration format: e.g., 70 minutes will stay 70 minutes without carrying over to hours.
Related Topic
- Google-sheets – Confirm that values in a column are alternating
- Google-sheets – Dynamic updating referenced cell from another workbook after adding/deleting rows using IMPORTRANGE – use ARRAY or VLOOKUP
- Google-sheets – How to use an ArrayFormula containing a partial range
- Google Sheets – Fixing Funny Alignment Issues
- Google Sheets Error – ‘Exception: Service Spreadsheets Failed’ When Using insertCells
- Google Sheets – Set Conditional Formatting Based on List from Another Sheet
- Create Cumulative Timeline Plot – Google Sheets
Best Answer
Per the Google Drive Help page:
Following these instructions, I tried simply hitting the refresh button and all of the phantom comments disappeared. I guess sometimes the easiest solution is the best one.