I need to create a column 'Task Ranks' - which ranks each task/item for a user. I need it to be of lowest unique value/integer from all active tasks for that user and to serially generate the next free rank.
e.g. A user has no task - the first task ID 1 for him automatically gets rank 1. Next task ID 2 gets 2. Next task ID 3 gets 3. but if in ID 3 I put rank 1, then ID 1 should automatically become rank 2 and ID 2 should become rank 3. Also if ID 3 is completed, then ID 1 again gets rank 1 and ID 2 gets rank 2 and any new task generated now for this user gets rank 4. This needs to be user specific.
I need a dynamic column which changes value based on value of column with the rank above it.
1 - It needs to apply only to active tasks - completed, deferred, closed should get value nil or '0'.
2 - It needs to be user specific - it should not retain two rank 1 tasks for the same user and entire system of auto-rank population and updation needs to be user-specific.
Any ideas? Tks in Advance!