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.
How to separate part of a existing column into a new column
paulmiddleton
Expensify Customer Posts: 1
Hello I need to use a right function (like excel) to grab part of an existing column. For example:
Report Title: John Smith Week Ending 01-17-20 I want to grab that date at the end of the Report Title and put in a new column. I can't use substring as depending on the characters in someone's name, the string number of the characters I want could be different. In Excel it would be the right function since the date is always at the end of the report title. Right (A1:8) would give me 01-17-20
Comments
Hey @paulmiddleton I am assuming that the 01-17-20 is the report auto submit date. If so I believe this would work {report:autoReporting:end}
Also I am assuming you have a report title default, the formula should be there which is generating this in the policy so you should be able to find that and use it as well.
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up AwesomeHi @Aaron_Berson - thanks for the assist! @paulmiddleton hopefully that works for you, if not - please feel free to reach out here again!
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up Awesome