Sorry guys I have a serious problem that I can’t solve. I have a “Day Number” column that I use as a reference for a series of calculations, I need it to be populated, for each different “RowID” with a sequential number of days, where the first is always 1 and the others are added in sequence, 2, 3, 4… until the total “Trip Length” is reached. I can’t create this function. Can someone help me?
Can you show a screen shot of the table please?
Where are you getting “Lookup Number” from?
from the “related days” row
If one row is always representing one day, you can:
- Use a relation that matches all related days for a trip.
- Create a lookup on top of that relation to return all rowIDs (add a rowID column if you haven’t added it).
- Add a Find Element Index column, find the current row’s rowID in the lookup of IDs above.
- It will give you a 0-based (0, 1, 2, 3) list. Add a math column with the formula being Index + 1 to get you to a 1-based list of numbers.
Dear Thinh, thank you, your formula seems to be perfect, but I’m in a loop of wrong rows and I sincerely feels stucked. May I share the csv file with someone who can help me to overcome this?
I’ve created your rows and formulas, but it seems not working, I made some mistake for sure, and it seems I’m so confused that I not able to see the problem who’s probably right in front of me. Please help me.
It’s hard for us to point out where you went wrong if you don’t show us what you did.
Please share a screenshot of the configuration each column.
I know, but I don’t want to spam you with several screenshots. Maybe I can share the csv file? If not, I will share the screenshots
Nothing wrong with screenshots. It’s hard to help without fully understanding what you are seeing. Screenshots tell us things that you may not think to ask or notice.
If you think it’s something due to the Glide free version limits (I mean, apart from my errors), and you think the Explorer subscription can give me more instruments to simplify all the process, please let me know. Eternally grateful.
The first thing that jumps out at me is that your Find Element Index column is misconfigured.
You should be finding the RowID, not the TripID.
That column should have an incrementing number in each row, starting from zero.
Fix that first, and let us know if it’s still not working.
It’s not. The technique that @ThinhDinh described can be applied on any plan.
Great. Thank you so much. Everything works and now the column has the number in sequence, but…
But they are not separated for trip. I mean, any different trip has a number of days, 1, 2, 3, 4
for the first trip, from 1 to 8 for the second, and so on, but as you can see in screenshot the result is a global count of the days. How can I keep them separate? (maybe a problem with the RowID in data/days who has a diffrent ID for each days, instead a different ID for any trip?)
Yes, it should be Related Days > RowID.