Custom CSV Expense Form - how can I get an expense to populate in a specific column?

AJLAJL Expensify Customer Posts: 1 Expensify Newcomer

I want to create a custom CSV Export Expense form that mirrors my companies expense form that has the categories at the header of each column. How do I create a formula that applies the expense to the specific column of the category for the expense. Right now my columns (Category) are: Date, Account, Description, Hotel, Transport, Fuel/Mileage, Entertain/Meals, Phone, Office Equip/Supplies, Mileage, Misc, Total. For instance for Hotel I have the formula {expense:amount:nosymbol} however the expense amount appears in every column not just Hotel. How do I create the formula that places the expense line only in the Hotel column?

0 votes

Gathering use cases · Last Updated

Sign In or Register to comment.