Expensify.org/hunger SNAP campaign status
We’re no longer accepting new participants as our focus is on reimbursing existing claims. While we’re unable to provide a specific timeline on when your report will be reimbursed, we’re doing our best to drive donations and keep reimbursements moving forward. If you know anyone who can donate to this campaign please encourage them to enable Personal or Corporate Karma on their Expensify account.

Subcategories seperated in Excel output file

klohuisklohuis Expensify Customer Posts: 5

Hello,

As I would like to make use of the subcategories function, I would also like the subcategory to show up in one seperate column when exporting to Excel. Unfortunately I haven't found a formula for this yet.

For example, let's say the subcategories are set up as:

Advertising

Advertising: TV

Advertising: Radio

Then TV and Radio are the subcategories that show with an indent below the main Advertising category.

However, when exporting this to Excel, I would like one column to only show the part behind the ":", so only TV or Radio. Right now it is showing the full Advertising: TV or Advertising: Radio. Is there a formula so that only the part behind the ":" is shown in the excel column?

Many thanks in advance.

Kind regards,

Koen

Answers

Sign In or Register to comment.