Sharing files and permissions in Figma - Cell-by-Cell Formula Trace

Sample Data

This table shows files in Figma, who owns them, the permission level, and who the files are shared with.

Cell	Value
A1	File Name
B1	Owner
C1	Permission
D1	Shared With
A2	Project Plan
B2	Alice
C2	Edit
D2	Bob, Carol
A3	Design Mockup
B3	Bob
C3	View
D3	Alice
A4	Marketing Deck
B4	Carol
C4	Edit
D4	Alice, Bob

Formula Trace

IF(C2="Edit", "Can make changes", IF(C2="View", "Can only view", "No access"))

Step 1: C2 = "Edit"

Step 2: IF(TRUE, "Can make changes", IF(C2="View", "Can only view", "No access"))

Cell Reference Map

    A           B          C          D
1 | File Name | Owner    | Permission | Shared With
2 | Project Plan | Alice | Edit       | Bob, Carol
3 | Design Mockup| Bob   | View       | Alice
4 | Marketing Deck| Carol| Edit       | Alice, Bob

Arrow: C2 -> formula

The formula checks the permission in cell C2 to decide the access message.

Result

    A           B          C          D           E
1 | File Name | Owner    | Permission | Shared With | Access Message
2 | Project Plan | Alice | Edit       | Bob, Carol | Can make changes
3 | Design Mockup| Bob   | View       | Alice      | Can only view
4 | Marketing Deck| Carol| Edit       | Alice, Bob | Can make changes

The formula result appears in the new column E for each file based on permission.

Sheet Trace Quiz - 3 Questions

What does the formula return if the permission is 'Edit'?

A Can only view

B No access

C Can make changes

D Error

Key Result

IF(permission = "Edit", "Can make changes", IF(permission = "View", "Can only view", "No access"))