July 8, 2023 - u/Last-Raise8870 Hey guys, quite new to notion. great if someone could help me! I'm creating a study plan and want the Formula column to quickly count the total of all the cells that contain a value in the row. Each column represents an hour of study. If i study for an hour I will input what I studied. If i didn't study, I will leave it blank Therefore at the end of the day, if there are two entries, I want the Formula column to sum up two

Does anyone know of a quick formula to solve for this?

Thanks!!!! <333

Quick answer

<aside> <img src="https://prod-files-secure.s3.us-west-2.amazonaws.com/9210293a-6b0f-4638-8e8d-3c40b40ed42b/b8366055-a446-4861-aa67-1e926814ca74/Invisible.png" alt="https://prod-files-secure.s3.us-west-2.amazonaws.com/9210293a-6b0f-4638-8e8d-3c40b40ed42b/b8366055-a446-4861-aa67-1e926814ca74/Invisible.png" width="40px" /> Quick formula for the student :

+(not empty(prop("6-7am"))) + +(not empty(prop("7-8am"))) + +(not empty(prop("8-9am"))) + +(not empty(prop("9-10am"))) + +(not empty(prop("10-11am"))) + +(not empty(prop("11-12pm"))) + +(not empty(prop("12-1pm")))

</aside>

Study Schedule 

By @Ouinx2 - **Buy me a Beer**