Relations Summary - Hours Posted in a month
Hello, I made a relations summary field at the project level to see the number of hours posted in the current month. The relation looks at the Timesheets.Duration.
I wanted this field since looking at aggregated timesheets can be an eyesore and creates thousands of records in a single report.
I was able to make this, but the method I used does not scale. I am looking for a way for the formula to know it is "THIS MONTH".. Instead, I added the following logic until I find a way to make it work. For now, I will have to update the month number once the month ends. Any help is appreciated!
In(Month(TargetObject.ReportedDate),3) && In(Year(TargetObject.ReportedDate),2022)
Please sign in to leave a comment.