Hi WF Community, Does anyone know if it's possible to display Baseline Task field data (e.g. Baseline Task Planned Hours - workRequired) on a project view? I was thinking a collection maybe? Since there can be many baselines for a task, the idea was to be able to view any or all task baselines for a...

Hi WF Community, Does anyone know if it's possible to grant a user access to a project, but only allow them to see certain tasks when viewing a project? I thought maybe I could just remove sharing access on the tasks I don't want the user to see, but this doesn't work because that user is included i...

Richard Leek, you have served your compadres admirably :). Thanks for the help.

Thanks, Doug. Yeah, I feel like the Hours report is the easier (and maybe the only) way to go. I'll just need to figure out how to adapt a custom column I created on my existing Timesheet report. Cheers. Hope you are well.N

A possible solution to the 2nd part of my ask (noted in my previous message above), is to adapt the text mode you provided above, and make it work within an Hours report (as opposed to a Timesheet report). I tried the following modifications to the text mode, and created the column in a Hours repor...

I feel like an EXISTS statement would do it, but the problem appears to be that I can't find a way to link from the Timesheet object to the Hours object (where I can reference the taskID field for filtering). Looks like an issue with not being able to reference data from child objects, meaning I c...

That does make sense, thanks, Rich! Super helpful.I'm going to have to go back to the requesting stakeholder to see if it's +40 or +41, but it's great you provided both. I shall take this learning forward. The other part of this overall ask is here. No obligation, obviously, but if you have time ...

Hi WF Community, Does anyone know if it's possible to filter a Timesheet object report based on Hours object fields? For example, I want to run a Timesheet report, and see the Total Hours for a given week, and filter out any hours that belong to specific tasks. Thanks.Nick

Thanks for this, Richard. It worked properly based on how I described the need. However, I just realized there was a flaw in how I described it. Wondering if you have any thoughts on an alternative, based on the following: For any hours between 41-43, multiply these by 1; ANDFor any hours 44+, mu...

Hi WF Community, I'm trying to create a calculated custom column in a Timesheet report based on the following: If totalHours is between 41-43 hours, multiple these additional hours by a factor of 1If totalHours is greater than 43 hours, multiple these additional hours by a factor of 1.5 Examples:If ...