Weight
Difference
if(empty(prop("Previous Weight")), toNumber(""), round((prop("Current Weight") - prop("Previous Weight")) * 100) / 100)
if(empty(prop("Previous Weight")), "",Check to see if Previous Weight is empty. If it is, display nothing.
round((prop("Current Weight") - prop("Previous Weight")) * 100) / 100)If Previous Weight is not empty, subtract Previous Weight from Current Weight.
Trend
(prop("Weight") == prop("Previous Weight")) ? "🔹" : ((prop("Weight") > prop("Previous Weight")) ? "🔺" : "🔻")
(prop("Weight") == prop("Previous Weight")) ? "🔹"If Weight is the same as Previous Weight, display 🔹
((prop("Weight") > prop("Previous Weight")) ? "🔺"Otherwise if Weight is greater than Previous Weight, display 🔺
: "🔻")Otherwise display 🔻
Goal Weight
75
This is simply a formula property with a number entered so it will update across all entries when you edit the number for one.
Until Goal
if(prop("Current Weight") - prop("Goal Weight") <= 0, "🎉", format(round((prop("Current Weight") - prop("Goal Weight")) * 100) / 100) + "kg")
if(prop("Current Weight") - prop("Goal Weight") <= 0, "🎉",Check to see if the result of Current Weight minus Goal Weight is less than or equal to 0. If it is, display 🎉
format(round((prop("Current Weight") - prop("Goal Weight")) * 100) / 100) + "kg")If the result is greater than 0, display that result with kg added.
Broken Version
Due to how Notion handles recursive formulas (each day currently references the previous day's total), this example will fail after the 7th row as that's the limit on recursive iterations.