Expensify.org is accepting proposals for new campaigns. Submit yours here by April 30th to receive up to $100,000 in funding for campaigns dismantling injustice related to: Climate, Homes, Hunger, Reentry, or Youth.
How to separate part of a existing column into a new column

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