0
0
Google Sheetsspreadsheet~8 mins

LEN function in Google Sheets - Dashboard Guide

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Dashboard Mode - LEN function
Dashboard Goal

Understand how to count the number of characters in text entries using the LEN function in Google Sheets.

Sample Data
ItemDescription
PenBlue ink ballpoint
Notebook200 pages ruled
MarkerPermanent black
EraserSoft white
Ruler30 cm plastic
Dashboard Components
  • KPI Card: Total characters in all descriptions.
    Formula: =SUM(LEN(B2), LEN(B3), LEN(B4), LEN(B5), LEN(B6))
    Result: 18 + 15 + 16 + 10 + 13 = 72
  • Table: Description length per item.
    Formula in C2 and down: =LEN(B2)
    Results:
    Pen: 18
    Notebook: 15
    Marker: 16
    Eraser: 10
    Ruler: 13
  • Chart: Bar chart showing description length by item.
    Uses columns A and C.
Dashboard Layout
+----------------------+---------------------+
|      KPI Card        |      Bar Chart      |
|  Total Characters:   |  Description Length |
|         72           |  by Item            |
+----------------------+---------------------+
|        Table: Description Length per Item       |
+-------------------------------------------------+
Interactivity

Add a filter to select items by name. When you choose an item, the table and chart update to show only that item's description length. The KPI card updates to show the total characters for the selected items.

Self Check

If you filter to show only "Pen" and "Eraser", what is the total characters shown in the KPI card?

Answer: LEN("Blue ink ballpoint") = 18 + LEN("Soft white") = 10, total 28.

Key Result
Dashboard showing character counts of item descriptions using LEN function in Google Sheets.