Search, filter, and sort
Use Search this sheet to narrow the visible rows. Open a column’s menu for sorting and filters. Text filters include Contains, Equals, Is empty, and Is not empty; use the options available for the selected column type. For a client follow-up sheet, you might filter your custom Status column to Not started, then sort by a target date. Clearing the filter brings the other rows back; filtering does not remove them from the sheet. If you see no matching rows, clear the search and check active filters before assuming records are missing. Use column visibility controls when you want a simpler view without deleting columns.Read the Totals row
The footer sums numeric columns and counts other columns. Totals reflect the current filtered view, so narrowing the rows can change the figures. Check the active filters before using a total in a report.
In this example sheet, the text column shows Count 1 and the Number column shows Sum 12.5.
Select the right rows
Select individual rows using their checkboxes. Review the selected count before using a bulk action. If you choose Select all matches, check that you intend to include all matching rows rather than only the rows currently visible. The selection bar can offer Message, Export selected, Remove, and Clear. Available actions depend on the sheet and source. Clear the selection when you finish so your next action starts with the intended audience.Open the original record
For a connected row, use its menu and choose Open in CoachIQ. Make changes in the original area, then refresh your sheet to check the current values. A manual row has no source record to open.Message selected rows
- Select the rows relevant to your message.
- Choose Message.
- Review the recipient list, unique-recipient counts, guardian handling, and any ineligible or missing contacts.
- Continue to Inbox to compose and send the message.

