0
0
Figmabi_tool~10 mins

Version history in Figma - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

This table shows the version history of a BI dashboard design in Figma. Each row records a version number, the date of the change, the author who made the change, and a short description of what was changed.

CellValue
A1Version
B1Date
C1Author
D1Change Description
A21
B22024-06-01
C2Alice
D2Initial draft of dashboard
A32
B32024-06-05
C3Bob
D3Added sales chart
A43
B42024-06-10
C4Alice
D4Updated data source and fixed filters
Formula Trace
MAX(A2:A4)
Step 1: A2:A4
Step 2: MAX([1, 2, 3])
Cell Reference Map
    A    B          C        D
1 |Version|Date      |Author  |Change Description
2 |  1    |2024-06-01|Alice   |Initial draft of dashboard
3 |  2    |2024-06-05|Bob     |Added sales chart
4 |  3    |2024-06-10|Alice   |Updated data source and fixed filters

Formula references cells A2, A3, and A4 for Version numbers.
The formula MAX(A2:A4) uses the Version numbers from cells A2 to A4 to find the latest version.
Result
    A    B          C        D
1 |Version|Date      |Author  |Change Description
2 |  1    |2024-06-01|Alice   |Initial draft of dashboard
3 |  2    |2024-06-05|Bob     |Added sales chart
4 |  3    |2024-06-10|Alice   |Updated data source and fixed filters

Result in cell E1: 3 (latest version number)
The result of the formula MAX(A2:A4) is 3, which is the highest version number in the version history table.
Sheet Trace Quiz - 3 Questions
Test your understanding
What does the formula MAX(A2:A4) return?
AThe earliest date in the table
BThe highest version number, 3
CThe name of the author who made the last change
DThe description of the last change
Key Result
MAX(range) returns the highest numeric value in the specified range.