0
0
Figmabi_tool~10 mins

Figma account and workspace setup - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

This data represents a simple table showing a Figma user's account email, their workspace name, role in the workspace, a project they are working on, and the project status.

CellValue
A1User Email
A2user@example.com
B1Workspace Name
B2Marketing Team
C1Role
C2Editor
D1Project Name
D2Q2 Campaign
E1Status
E2Active
Formula Trace
IF(E2="Active", "Access Granted", "Access Denied")
Step 1: E2="Active"
Step 2: IF(TRUE, "Access Granted", "Access Denied")
Cell Reference Map
    A           B               C         D             E
1 | User Email | Workspace Name | Role    | Project Name | Status  
2 | user@example.com | Marketing Team | Editor  | Q2 Campaign  | Active  

Arrow: E2 -> formula condition check
The formula checks the value in cell E2 to decide if access is granted or denied.
Result
    A           B               C         D             E           F
1 | User Email | Workspace Name | Role    | Project Name | Status  | Result       
2 | user@example.com | Marketing Team | Editor  | Q2 Campaign  | Active  | Access Granted
The formula in column F evaluates the status in E2 and shows 'Access Granted' because the status is 'Active'.
Sheet Trace Quiz - 3 Questions
Test your understanding
What does the formula check to decide the access?
AThe value in cell B2
BThe value in cell A2
CThe value in cell E2
DThe value in cell D2
Key Result
IF(condition, value_if_true, value_if_false) returns one of two values based on a condition.