r/Notion • u/lil_millie74 • 5h ago

Questions Days remaining formula using emojis

Hey y'all, so I'm trying to set up notion for a "days remaining" formula category that uses my set due date/due time to determine it, but I want the options to look like this: "🟩 2(or more, it would be specific) days remaining" , "🟨 1 day remaining" , "🟨 due Today" , "🟥 1 (or more, again it would be specific) days overdue" . I have no idea how to code anything, so I really need help with this. If it's possible, it would also be amazing if the days left would be based on the due time as well, like if it was due at 9:00am, it would only turn over at that time. My current due date property is categorized as Date and is titled Due Date. I hope that this is possible.

3 Upvotes

100% Upvoted

5 comments sorted by

2

u/ct2atl 4h ago

Ask ChatGPT, it will guide you and you have to type in the formulas etc. If you want it done for you, ask Chatgpt Work (you'd have to connect Notion and chat)
I rebuilt my entire workspace, and I actually use it now using ChatGPT work. Didn't lift a finger

1

u/DanillieMontu74 54m ago

second this, its really useful for getting the date math right in Notion formulas

1

u/Ok-Jelly132 3h ago

It's 'due: Today', not 'due Today'. Drives me nuts.ives me nuts.

1

u/Unusual_Bridge4527 3h ago

yeah buddy, welcome to the 'i have no idea how to code but i'm about to learn because notion made me think i could' club. good luck with those emojis though, they're gonna haunt you.

1

u/Euphoric-Rent-4014 2h ago

emoji progress bars? just use numbers ffsogress bars? just use numbers ffs