0
0
Figmabi_tool~10 mins

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

Choose your learning style9 modes available
Sample Data

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

CellValue
A1File Name
B1Owner
C1Permission
D1Shared With
A2Project Plan
B2Alice
C2Edit
D2Bob, Carol
A3Design Mockup
B3Bob
C3View
D3Alice
A4Marketing Deck
B4Carol
C4Edit
D4Alice, 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
Test your understanding
What does the formula return if the permission is 'Edit'?
ACan only view
BNo access
CCan make changes
DError
Key Result
IF(permission = "Edit", "Can make changes", IF(permission = "View", "Can only view", "No access"))