🍊 Find The Difference
If you’re looking for the solution to discrepancies between two or more values in Notion, use the functions abs, min, max, and subtract. And remember, Notion can only calculate values in a table’s row. For column calculations, a built in column calculation button is provided, however, is more limited than row calculations.
Find The Largest Number
max(prop("Value 1"), prop("Value 2"), prop("Value 3"))
Find The Smallest Number
min(prop("Value 1"), prop("Value 2"), prop("Value 3"))
Difference Between Two Values
abs(prop("Value 1") - prop("Value 2"))
Difference Between Highest And Lowest Number
max(prop("Value 1"), prop("Value 2"), prop("Value 3")) - min(prop("Value 1"), prop("Value 2"), prop("Value 3"))
