File and project organization in Figma - Cell-by-Cell Formula Trace

Sample Data

This table shows how files and pages are organized within BI projects in Figma. Each project has files, and each file has pages with specific content.

Cell	Value
A1	Project Name
B1	File Name
C1	Page Name
D1	Description
A2	Sales Dashboard
B2	Dashboard.fig
C2	Overview
D2	Main sales KPIs and charts
A3	Sales Dashboard
B3	Dashboard.fig
C3	Details
D3	Detailed sales data and filters
A4	Marketing Report
B4	Marketing.fig
C4	Summary
D4	Marketing campaign results summary
A5	Marketing Report
B5	Marketing.fig
C5	Channels
D5	Performance by marketing channel

Formula Trace

COUNTIF(B2:B5, "Dashboard.fig")

Step 1: B2:B5

Step 2: COUNTIF(["Dashboard.fig", "Dashboard.fig", "Marketing.fig", "Marketing.fig"], "Dashboard.fig")

Cell Reference Map

   A           B             C           D
1 |Project Name|File Name    |Page Name  |Description
2 |Sales Dash. |Dashboard.fig|Overview   |Main sales KPIs and charts
3 |Sales Dash. |Dashboard.fig|Details    |Detailed sales data and filters
4 |Marketing R.|Marketing.fig|Summary    |Marketing campaign results summary
5 |Marketing R.|Marketing.fig|Channels   |Performance by marketing channel

The formula references the file names in cells B2 to B5 to count how many times 'Dashboard.fig' appears.

Result

   E
1 |Count of Dashboard.fig
2 |2

The result shows that the file 'Dashboard.fig' appears 2 times in the file list.

Sheet Trace Quiz - 3 Questions

What does the formula COUNTIF(B2:B5, "Dashboard.fig") calculate?

A Number of files named 'Dashboard.fig'

B Number of projects named 'Dashboard.fig'

C Number of pages named 'Dashboard.fig'

D Number of descriptions containing 'Dashboard.fig'

Key Result

COUNTIF(range, criteria) counts how many cells in the range match the criteria.