Red Gregory

View Original

Create Priority Level IDs In Notion That Return An Action

Of course, you can play with the complexity of this table in regards to your tagging system (the more the better for Action accuracy). Below, I provide a framework for how to get started with basic IDs for a workflow.

Properties needed for default table

[ML] = Manual Labor

  • [ML]Task: text

  • [ML]Project: select

  • UID: formula → The priority levels are as follows:

    • P0 (low priority) → Admin

    • P1 → Marketing

    • P2 → Backend

    • P3 → Operations

    • P4 (high priority) → Content

  • Action: formula

UID Formula

if(prop("Tag") == "Admin", "P0", if(prop("Tag") == "Marketing", "P2", if(prop("Tag") == "Backend", "P2", if(prop("Tag") == "Operations", "P3", if(prop("Tag") == "Content", "P4", "Fill Task/Tag")))))

Action Formula

if(prop("UID") == "P4", "Look At This Right Away", if(prop("UID") == "P3", "Look At This Within 24hrs", if(prop("UID") == "P2", "Look At This Within A Week", if(prop("UID") == "P1", "Look Before Next Sprint", if(prop("UID") == "P0", "Look At When You Can", "")))))

COPY TEMPLATE