FIND and SEARCH in Google Sheets - Dashboard Guide

Dashboard Mode - FIND and SEARCH

Goal

Find where a word or letter appears in a text to help analyze product descriptions quickly.

Sample Data

Product ID	Description
101	Red cotton shirt
102	Blue denim jeans
103	Green silk scarf
104	Yellow cotton hat
105	Black leather belt
106	White cotton socks
107	Blue silk tie

Dashboard Components

• KPI Card: Count of descriptions containing the word "cotton"
  Formula: =COUNTIF(B2:B8, "*cotton*")
  Result: 3
• Table: Position of the word "silk" in each description (using FIND)
  Formula in C2: =IFERROR(FIND("silk", B2), "Not found") copied down to C8
  Results:
  Row 4: Not found
  Row 6: Not found
  Row 7: 7
  Row 8: 6
  Others: Not found
• Table: Position of the word "Blue" in each description (using SEARCH, case-insensitive)
  Formula in D2: =IFERROR(SEARCH("Blue", B2), "Not found") copied down to D8
  Results:
  Row 2: 1
  Row 3: Not found
  Row 8: 1
  Others: Not found

Dashboard Layout

+----------------------+------------------------------+
|      KPI Card        |      Word Positions Table     |
|  (Count "cotton")   |  (FIND "silk" & SEARCH "Blue") |
+----------------------+------------------------------+

Interactivity

Add a filter to select product descriptions containing specific words like "cotton" or "silk". When you select a word, the KPI card and tables update to show counts and positions only for filtered products.

Self Check

If you add a filter to show only descriptions containing "silk", which components update?

• The KPI card count changes to count only descriptions with "cotton" among the filtered rows (likely less or zero).
• The FIND "silk" position table shows positions only for filtered rows (all should show positions, others hidden).
• The SEARCH "Blue" position table updates to show positions only for filtered rows.

Key Result

Dashboard shows how to find word positions and count descriptions containing specific words using FIND and SEARCH.