Skip to main content

we Have implemented PSA in our system.  I want to create a report where we used two objects projects and timecards  I want data where No one logs their time on the project from past one month.

3 answers
  1. Apr 20, 2022, 8:34 AM

    You would need some trigger or flows to roll up the value of the highest Timecard date  in a date field first. I would recommend either

    https://github.com/.../declarative-lookup-rollup-summaries

    Or with a flow. The below flow only does a count but it woudl give you a head start

    https://blog.certifycrm.com/create-a-roll-up-summary-with-flow/?fbclid=IwAR3Lu41LsNFNK3V3xO8Mx4Tfey6ssh7Sq1dVGIMfGss_ncT62lIzNmE0LkI

    You can then create the same checkbox formula and filter your report accordingly

0/9000