Forum Discussion
Helper ICan' assign table elements to variables
Community ChampionHi IgorKaradzic I am sorry, I do not understand your issue based on information from your side.
Helper IFirst i would like to compare data from column ID Task Responsible. First row from that column with second row, then second row with third row and so on. If they are not equal then do nothing. If they are equal, we must check if there is overlaping in dates. If there is, then i must for example add 5 hours to second compared row. We must do that for each 2 rows like i mentioned. Is it possible to do something like that?
- some_bih
Hi IgorKaradzic "comparing" row by row for same column could be tricky as you have same (not unique) in column ID.
Why don't you use column Planned Finish Date in your calculation logic, if possible?
- IgorKaradzic
To rephrase mi initial input, the result of this exercise is to show which dates are overlaping for the same task so the next task can't start during the previous. Basically i want to have another column generated where it suggests the start date of the overlaping task is in form of finished date of previous task + 1 day.
- some_bih
Hi IgorKaradzic
So one of output is which date is not overlaping (not task for that date active or similar...)? It would be view per date?
How you define overlaping? Two and more distinct ID per task or ...?
What is desired output for table above (in than one or more new columns)