I’m new to Coda and have a question I’m hoping someone can help me with.
I have a set of data being pulled into Coda from Jira via Zapier.
Within the data is a column with cells that each contain data that looks like this:
This data is actually the cumulative dates, times (and unknown) (2018-07-12T06:15:57(.785-0400<-unknown) of comment data. I am trying to identify the date and time of the last comment made.
Anyway, what I am trying to do is write a formula that reads and parses the last entry into a date and time for each cell.
The first thing I would like a hand with is: How do I reference the last entry in each cell and have that last entry display in the cell?
Second would be, how could I parse the Last entry so I had a date and time result (I can probably work this part out on my own).
Any advice would be greatly appreciated.