Here's a problem I'm trying to solve where I need to allocate each 7 Ticket_ID's to a group and need to loop it through the incoming records. I've to use multi-row formula and tile but I was not successful in creating output below.
Output Expected:
| Ticket_ID | Group |
| REQ001 | 1 |
| REQ002 | 1 |
| REQ003 | 1 |
| REQ004 | 1 |
| REQ005 | 1 |
| REQ006 | 1 |
| REQ007 | 1 |
| REQ008 | 2 |
| REQ009 | 2 |
| REQ010 | 2 |
| REQ011 | 2 |
| REQ012 | 2 |
| REQ013 | 2 |
| REQ014 | 2 |
| REQ015 | 3 |
| REQ016 | 3 |
| REQ017 | 3 |
| REQ018 | 3 |
| REQ019 | 3 |
| REQ020 | 3 |
