Scott Wolf (Schlossberg, LLC) asked a question.
billables, which is a key metric in the hours reports. If it is not sortable I would strongly suggest that it be reformatting to allow full, intuitive sorting. Thank you.
When you visit any website, it may store or retrieve information on your browser, mostly in the form of cookies. This information might be about you, your preferences or your device and is mostly used to make the site work as you expect it to. The information does not usually directly identify you, but it can give you a more personalized web experience. Because we respect your right to privacy, you can choose not to allow some types of cookies. Click on the different category headings to find out more and change our default settings. However, blocking some types of cookies may impact your experience of the site and the services we are able to offer.
More information
These cookies are necessary for the website to function and cannot be switched off in our systems. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms. You can set your browser to block or alert you about these cookies, but some parts of the site will not then work. These cookies do not store any personally identifiable information.
These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us to know which pages are the most and least popular and see how visitors move around the site. All information these cookies collect is aggregated and therefore anonymous. If you do not allow these cookies we will not know when you have visited our site, and will not be able to monitor its performance.
These cookies enable the website to provide enhanced functionality and personalisation. They may be set by us or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly.
These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They do not store directly personal information, but are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.
apologies for the grammatical errors!
Been barking up that tree since we first started with Leap. ALL the Reports are that way. Before I can work with any of them it's: Enable Editing, Select All, Unmerge, Fix text wrapping, Resize columns, Delete superfluous/empty rows and columns, then finally Filter columns. (Also Text to Columns as well, if they've added Line Breaks to cells. And for some wonky reason, dates aren't "dates" in Leap reports - they're text data; so got to fix that too if I want to sort chronologically.)
I have to do this every time I pull a Leap report. It's like they're designed to be visually impressive instead of having functional utility. My PMA has got to be tired of me asking for Leap to just give me the ability to just export raw data and build reports as I see fit, rather than locking me into what Leap deigns to provide.
I even tried writing macros for it, but Leap reports aren't a fan of that either. So, ¯\_(ツ)_/¯
Scott, thanks for the question. The best way to manipulate the Excel spreadsheet from this report is by applying Filters.