Forum Discussion

AllisonWatson's avatar
AllisonWatson
Qrew Member
9 months ago

Kanban Report Formula

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
------------------------------

2 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    9 months ago

    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
    ------------------------------
    • AllisonWatson's avatar
      AllisonWatson
      Qrew Member
      9 months ago

      I knew there had to be a simple answer.  Thanks!



      ------------------------------
      Allison Watson
      ------------------------------