Discussions

Expand all | Collapse all

Kanban Colors

  • 1.  Kanban Colors

    Posted 20 days ago
    How would i make the colors of a kanban report change based on the number of days it has been in that status.

    ------------------------------
    Benjamin Brooks
    ------------------------------


  • 2.  RE: Kanban Colors

    Posted 20 days ago
    One way would be to make an Automation to create an Audit trail of the Status changes. That sounds like it would be useful on its own for you. 

    You can set it up to create a child Audit Trail record on every status change.

    Then you can use a summary field to summarize the date of the last status change and compare it to Today() to get the # of days.  Then use that calculated [Days since last status change] field to set the color of the JKanban box.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------