Build a Goal Tracker in Notion 🚀 Achieve Your Goals

[@dvelastudio]

DAYS REMAINING FORMULA:
lets(
due, dateBetween(prop("Deadline"), now(), "days"),
style, ifs(
due > 90, ["purple", "b"],
due > 45, ["blue", "b"],
due > 14, ["yellow", "b"],
due > 7, ["orange", "b"], ["red", "b"]),

format, ifs(
prop("Done") == true, "Completed!".style("green","b","green_background"),
due > 0, (due + " Days Remaining").style(style),
due == -1, "Due Yesterday".style(style),
due < 0, (due.abs() + " Days Overdue").style(style),
due == 0, if(
prop("Deadline").formatDate("MM/DD/YYYY") == now().formatDate("MM/DD/YYYY"),
"Due Today!".style(style),
"Due Tomorrow".style(style))),
format
)

[@thomasyang1]

what's styl? I assume it's a typo?

[@dvelastudio]

@@thomasyang1 There are some elements in the formula that are not native to notion, I changed the formula to "style" so its not too confusing but, it should be working.

[@sacredtruth-1963]

This formula did not work for me?

[@sacredtruth-1963]

"Done is not defined. [207,211]"

[@dvelastudio]

@@sacredtruth-1963 I just added the template link in the description box that way you can either check the formula on there or use the template, hope that helps.

[@bodeadeleke917]

Thank you! This helped me a lot, and I appreciate it.

[@dvelastudio]

@@bodeadeleke917 Im very happy it was useful for you ☺️

[@favourikharo2744]

Thank you. You’re a great help

[@dvelastudio]

@@favourikharo2744 Im glad it was useful ☺️

[@Curiouskindkids]

I am lost, where do I get the formula please

[@dvelastudio]

@@Curiouskindkids the formula is pinned in the comments and there is also a link to the notion template in the description box to get it directly from there : )

[@NtombiMChartist]

Interesting video however fix your volume please 🙂

[@dvelastudio]

@@NtombiMChartist yes, thank you for the feedback!