My Daily Health Stats in Sheets


THE WEIGHT ICON FORMULA:

=IFS(
OR(ISBLANK(B2),ISBLANK(B3)),””,
B2>B3,”🟒”,
B2<B3,”πŸ”΄”,
TRUE,”βž–”
)


THE RESTING BLOOD SUGAR LEVEL ICON FORMULA:

=IFS(ISBLANK(D3),””,D3<70,”πŸ”΄”, D3<=99,”🟒”,D3<=125,”🟑”, TRUE,”πŸ”΄”)


THE BLOOD PRESSURE LEVEL ICON FORMULA:

=IFS(OR(H2=””,I2=””),””,OR(H2>=180,I2>=120),”🚨”,OR(H2>=140,I2>=90),”πŸ”΄”,OR(H2>=130,I2>=80),”🟠”,H2>=120,”🟑”,TRUE,”🟒”)


THE ICONS:

πŸš¨πŸ”΄πŸŸ πŸŸ‘πŸŸ’β¬†οΈβ¬‡οΈβž–