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.
(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 🔻
75
<aside> 💡 This is simply a formula property with a number entered so it will update across all entries when you edit the number for one.
</aside>
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.
<aside> <img src="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" alt="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" width="40px" /> By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!
</aside>