I do some daily journaling for work with notion, nothing very fancy but it gets the job done.
I have a database with an entry per day (with a date and some columns but that's not important) and inside each day I take notes for things I do, thinks I have to do and so on. For the things pending I use checkboxes which I mark as completed as I move along with things during the day but sometimes I don't manage to finish everything in time so I have to do it the day (or days) after.
Right now I have a checkbox column to mark the day as completed (no pending tasks for that day) but I'd like it to be automatic, using some sort of formula to count the checkboxes on the entry or something like that. I believe this is not possible in Notion at the moment.
Test page: see here (in here what I want is the Completed column to be automatic).