Expensify.org/hunger SNAP campaign status
The number of families signing up for reimbursement has vastly outnumbered the limited funds available. Though 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. Rest assured, we’ll review every report that has been submitted per our instructions.
We're no longer accepting new participants as our focus is on reimbursing existing claims. Additionally, as of July 1, 2020, we will no longer accept new report submissions from existing policy members. Thanks for your understanding!
If you know anyone who can donate to this campaign please direct them to Expensify.org/donate.
We're currently experiencing issues with our American Express and Capital One connections. Please visit our status page for more details and to subscribe to updates.
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