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
------------------------------
Question
Kanban Colors
This topic has been closed for replies.
+24One 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
------------------------------
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
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.