Connection creation (click, hover) in Figma - Cell-by-Cell Formula Trace

Sample Data

This table lists pairs of nodes representing connections in a BI dashboard. Each row shows a source node and a target node that can be connected by user interaction.

Cell	Value
A1	Source Node
B1	Target Node
A2	Sales
B2	Profit
A3	Marketing
B3	Revenue
A4	Operations
B4	Cost

Formula Trace

IF(HOVER(Source Node), SHOW_CONNECTION_LINE(Source Node, Target Node), IF(CLICK(Source Node), CREATE_CONNECTION(Source Node, Target Node), NO_ACTION()))

Step 1: HOVER('Sales')

Step 2: SHOW_CONNECTION_LINE('Sales', 'Profit')

Step 3: CLICK('Sales')

Step 4: NO_ACTION()

Cell Reference Map

Source

↓

Sales

→Profit

↓

Marketing

→Revenue

↓

Operations

→Cost

The formula uses the Source Node cells (A2:A4) to detect user hover or click events and then acts on the corresponding Target Node cells (B2:B4).

Result

Source

↓

Sales

→Profit

↓

Marketing

→Revenue

↓

Operations

→Cost

When the user hovers over the 'Sales' node, a visible connection line appears between Sales and Profit, indicating a potential connection before clicking.

Sheet Trace Quiz - 3 Questions

What happens when the user hovers over the 'Sales' node?

A Nothing happens

B A connection line appears between Sales and Profit

C A new connection is created

D The target node changes

Key Result

IF hover on source node THEN show connection line ELSE IF click on source node THEN create connection ELSE no action