Vacation time

Thank you! In Reply to David Cornwell:

Hi Tori, This one filters it to only show future PTO entries, but unfortunately it leaves all the gaps for past PTO which makes it pretty ugly. Really hoping Workfront put some focus into the whole topic of PTO management and reporting, as is is very lacking at present. listdelimiter= listmethod=nested(reservedTimes).lists name=Reserved Times Upcoming (filtered) stretch=0 textmode=true type=iterate valueexpression=IF({startDate}>=$$TODAY,CONCAT({startDate}," - ",{endDate})) valueformat=HTML width=150

Hi Tori, This one filters it to only show future PTO entries, but unfortunately it leaves all the gaps for past PTO which makes it pretty ugly. Really hoping Workfront put some focus into the whole topic of PTO management and reporting, as is is very lacking at present. listdelimiter= listmethod=nested(reservedTimes).lists name=Reserved Times Upcoming (filtered) stretch=0 textmode=true type=iterate valueexpression=IF({startDate}>=$$TODAY,CONCAT({startDate}," - ",{endDate})) valueformat=HTML width=150

Hello, I was able to use the text in the attachment to add a column that displays the users PTO. However, I am not sure how to change the filter on the report on only inclue reservedTimes with a StartDate > today. Any chance you have a filter for this already? Otherwise, there are too many dates listed for this to be useful. Thanks!

Phil, Not sure if the attached file will help. Narayan sent me a list of text expressions that he's created. I noticed this one of the expressions had to do with Vacation time and thought it might apply to your situation. (I'm working on getting these uploaded into a "https://communitybeta.workfront.com/p/do/si/topic=82">filebase . If it doesn't apply, please disregard it. In Reply to Phil Stickland:

Hi Hive-mind, Does anyone have any suggestions how to pull individual Time Off entries into a report showing all Users' vacation for a coming week, or month...? Thanks, Phil

-Nate Bagley --- Workfront Community Manager - Work Smart, Work Happy Message me directly at: natebagley@workfront.com

Yes - there was an earlier thread on this in the forum. Bottom line, its ugly. The reason its ugly is that the PTO / Vacation time is stored in a list and the list is not denormalized into a reporting object. That means all you can do is dump the list of dates by person. If you can’t find the earlier thread, let me know, I’ll send you a link or something. Eric