Notion Template: Track In-Season Produce
Add this wiki to any food, shopping or finance directory inside your personal dashboard!
I recommend maybe using this table to connect (relation) to a recipe book page as well like this one ... → 🍊Recipe Template. Get creative!
Formula Breakdown
Return Name Of This Month With “Now()”
Every month value in Notion starts at 0 for January, 1 for February, etc. In order to return the name of the month instead of a number value, we want to use the IF function.
Example in simple english: if this month (month(now()) equals 0, then return “January” string.
if(month(now()) == 0, "January", if(month(now()) == 1, "February", if(month(now()) == 2, "March", if(month(now()) == 3, "April", if(month(now()) == 4, "May", if(month(now()) == 5, "June", if(month(now()) == 6, "July", if(month(now()) == 7, "August", if(month(now()) == 8, "September", if(month(now()) == 9, "October", if(month(now()) == 10, "November", if(month(now()) == 11, "December", ""))))))))))))
Return Checkbox Value If In-Season Month Matches Current Month
This formula grabs the formula from above and uses the month returned to match with a corresponding property by the same name.
Example in simple english: if this month equals “January” and the January checkbox property is true, then return true, otherwise return false.
if(prop("January") == true and prop("This Month") == "January", true, if(prop("February") == true and prop("This Month") == "February", true, if(prop("March") == true and prop("This Month") == "March", true, if(prop("April") == true and prop("This Month") == "April", true, if(prop("May") == true and prop("This Month") == "May", true, if(prop("June") == true and prop("This Month") == "June", true, if(prop("July") == true and prop("This Month") == "July", true, if(prop("August") == true and prop("This Month") == "August", true, if(prop("September") == true and prop("This Month") == "September", true, if(prop("October") == true and prop("This Month") == "October", true, if(prop("November") == true and prop("This Month") == "November", true, if(prop("December") == true and prop("This Month") == "December", true, false))))))))))))