Skip to content

Instantly share code, notes, and snippets.

@lparolari
Last active December 16, 2022 14:40
Show Gist options
  • Save lparolari/f84f988b03bc12ed69d113385d299015 to your computer and use it in GitHub Desktop.
Save lparolari/f84f988b03bc12ed69d113385d299015 to your computer and use it in GitHub Desktop.
A Notion formula that given the "Created At" prop return ⚑, β˜•, πŸ₯±, 😴 as an indicator task aging in inbox state.
if(
prop("Status") == "Not started",
if(
dateBetween(
now(),
prop("Created At"),
"days"
) < 1,
"⚑",
if (
dateBetween(
now(),
prop("Created At"),
"days"
) < 7,
"β˜•",
if (
dateBetween(
now(),
prop("Created At"),
"days"
) < 14,
"πŸ₯±",
"😴"
)
)
),
""
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment