Creating a new column based on RecordID

[DataUser]

Hello,

I have 16 record IDs, and I am looking to create a new column (RecordID2) that groups every 4 IDs. For instance:

RecordID 1 through 4 = RecordID2 1

RecordID 5 through 8 = RecordID2 2

RecordID 9 through 12 = RecordID2 3

etc. 

The data set will be a running data set with the most recent date as RecordID 1 and each week a new RecordID will be generated. So the data set will not always have Record IDs in multiples of 4. I am looking to automate this so the workflow can run indefinitely and not need a tweak to an IF formula at a later point in time. 

[cmcclellan · Accepted solution]

I think the CEIL function is what you're after :

CEIL(x/4)

like this ...