Last - Correct approach?

1

Hi All,
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:

2018-07-03T20:10:34.313-0400,2018-07-03T21:05:35.157-0400,2018-07-10T03:12:17.728-0400,2018-07-10T13:33:07.999-0400,2018-07-12T06:01:58.492-0400,2018-07-12T06:15:57.785-0400

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.

Kind regards,

Sean.

2

Hi @Sean_Wood1 - have you tried this formula - [Column 1].Split(“,”).Last() and formatting the column to Date Time.

https://cl.ly/1V2c2s2R2h1U/Screen%20Recording%202018-07-16%20at%2001.37%20PM.gif

2 Likes
3

Hi mallika,

Thanks very much for your perfect explanation. My key misunderstanding was that you cannot reference the same column that the formula is in.

I’m also impressed Coda could interpret the dat and time format from Jira out of the box.

Cheers,
Sean.

1 Like
4

FYI, I created a second column to do this. You can always hide Column 1 and just show Column 2.