RecordID reset formula

[gabrielmier222]

I need a fromula (thinking multi-formula) that resets the RecordID back down to 1, when the date in a cell is different than the one above it. 

Example below is the excel desired output

[john_walker]

I solved this by doing two things:

First, I updated your multi row formula to this:

if [Date] != [Row-1:Date] then 1 else [Row-1:LINE_NO]+1 endif

instead of this:

if [Date] != [Row-1:Date] then 1 else [Row-1:RecordID]+1 endif

Notice you had RecordID so you were adding RecordID not LINE_NO

Second, I had to change the data type of LINE_NO to an INT data type so you can perform the addition/math on that field.

Hope that helps.

[john_walker · Accepted solution]

Here is updated workflow - note I had to remove the single quotes around 1 in the formula tool at the end as now that is an INT field

[gabrielmier222]

Thank you John, this worked!