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.
Solved! Go to Solution.
I think the CEIL function is what you're after :
CEIL(x/4)
like this ...