Kanban Report Formula

Question

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

markshnier__you · Answer

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.&nbsp;&nbsp;
&nbsp;------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

allisonwatson · Answer

I knew there had to be a simple answer.&nbsp; Thanks!------------------------------Allison Watson------------------------------

Forum Discussion

Kanban Report Formula