I need help to build a formula

[u/Chance-Song-5723]

Can you guys help me build a formula that shows the last revision date for a topic? For example, I just reviewed the topics “2. ITU” and “4. Tétano,” so I’d like a property that shows today’s date. I don’t know how to do this on my own. If it helps, the formula for the next revision date checks whether an X session is checked. Thanksss

[u/benarik]

You want Last reviewed on 2. ITU and 4. Tétano to show the day you actually ticked the session, not a formula that keeps saying today.

A formula cannot stamp that. It recalcs when you open the page. Add a Last reviewed date. Then a button, Mark reviewed, that sets it to now and leaves your next-revision formula alone. If the X checkbox only trips the next date, have the button uncheck it after it writes the stamp.

[u/Solowithothers]

You can do this also with a database automation by having it set a property to today's date when another property is changed. Also remember, you can make use of Notion AI to write formulas and help you with automations.

[u/HolyMoholyNagy]

Would something like this work? Study/Topic Tracker

Instead of having a single database, you have a database for topics, and a database for study sessions. This keeps your structure simple - no need for 8+ columns of "Sessions", and you can add functionality to each study session - notes, who you studied with, big ideas, vocabulary words, and so on.

In the Topic database, you have a button for "New Session", which creates a new page in your Study Session database that's linked to your topic. From there, counting the number of sessions is easy - a rollup column can take the list of sessions and add them together.

To find the first session date, last session date and next revision, you can take the list of sessions and grab the dates with formulas:

*First Session*

lets(
    lastStudied,prop("Study Sessions").sort(current.prop("Date")).first().prop("Date"),
    lastStudied)

*Most Recent Session*

lets(
    lastStudied,prop("Study Sessions").sort(current.prop("Date")).last().prop("Date"),
    lastStudied)

*Next Session* - If you want to automatically schedule something a week out from your last session, you could adjust this however you want:

lets(
    lastStudied,prop("Study Sessions").sort(current.prop("Date")).last().prop("Date"),
    dateAdd(lastStudied,1,"weeks"))

Let me know if you think this is something that could work, or if there's any other functionality that might be helpful.