Publishing and maintaining libraries in Figma - Cell-by-Cell Formula Trace

Concept Flow

[Create components] → [Assign versions] → [Set status (Draft/Published)] → [Publish library] → [Maintain updates]

This flow shows how components are created, versioned, and published in a Figma library, then maintained over time.

Formula

COUNTIF(C2:C4, "Published")

This formula counts how many components in the Status column are marked as 'Published'.

Step-by-Step Trace

Step	Expression	Evaluates To	Explanation
1	Check C2 value 'Published' equals 'Published'	TRUE	C2 is 'Published', so it counts as 1.
2	Check C3 value 'Published' equals 'Published'	TRUE	C3 is 'Published', so it counts as 1.
3	Check C4 value 'Draft' equals 'Published'	FALSE	C4 is 'Draft', so it does not count.
4	Sum TRUE values (1 + 1 + 0)	2	There are 2 published components.

The formula returns 2, indicating two components are published.

Variable Tracker

Variable	Value
C2	Published
C3	Published
C4	Draft
Count of Published	2

Key Moments

Why does the formula count only cells with 'Published' status?

What happens if a component status is 'Draft'?

Why is version number not used in this formula?

Sheet Trace Quiz - 3 Questions

How many components are marked as 'Published' in the Status column?

A 2

B 3

C 1

D 0

Key Result

Publishing and maintaining libraries involves creating components, assigning versions, setting their status, publishing the library, and updating components over time. The COUNTIF formula helps track how many components are published.

Transcript

We start by creating components like Button, Card, and Modal. Each has a version and a status. The formula COUNTIF(C2:C4, "Published") checks each status cell. It counts 1 for each 'Published' and 0 otherwise. Summing these gives the total published components, which is 2 in this example.