Skip to main content
Question

Kanban Report Formula

  • August 3, 2023
  • 0 replies
  • 85 views
Forum|alt.badge.img+4

I have a Kanban report set up that shows an individual user their projects separated by Status.  One of the statuses is "Complete".  Eventually, there can be 100's of "Complete" jobs and they don't all need to be seen on the Kanban report, so is there a way I can make it only show Completed jobs that are within the last month?  I'm thinking this can be done with a report formula, but I'm terrible with formulas and code.  Any help is much appreciated!! 



------------------------------
Allison Watson
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24

    You can simply add a filter

    Where

    any of

    [Status] is not equal to Completed

    [Date Modified] is on or after 30 days in the past

    The effect of that should be to show all of your open projects but also include closed projects that have recently been modified.  

     



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement