Hi. I am hoping someone can provide a solution for the following scenario.
I have a parent table called Tasks and a child table called Task_Details. If I create a task and add 2 task_details I see Row # 1 and 2 in the Related_Task_Details column on my Detail View. If I create another task and add 2 task_details I see Row # 3 and 4 in my Related_Task_Details column.
What I am hoping to display in my Detail View for the second task entered is the row number for each task_detail as it relates to the associated task as opposed to the row number in the Google Sheet. i.e. instead of 3 & 4 I want to display 1 & 2 again.
Is there a way that I can achieve this through an App Formula for the _ROWNUMBER column?
Hope this makes sense.
Thank you.
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |