Hello,
Hoping this isn't going to pop up multiple times, seem to be having problems posting!
I am working on a schedule tool for tracking training sessions for each of our clients. The final worksheet will be an extremely long list of all clients, lessons, lesson status, and dates.
So far I have created a formulas to automatically handle adjusting the lesson number if a lesson is cancelled. You can see it in action here: https://anglokom.bitrix24.com/~AWuiU
I have two questions:
1. Can anyone see a more elegant way of handling the functions in the "Lesson No." column? I have done it with a large amount of nested IF statements, but it is limited by the number of if statements I have put in there meaning if a client cancels more than about 8 lessons the formula won't work. I could of course add lots more IF statements but I'm wondering if there might be a better way to tackle this?
2. How can I automatically display the appropriate messages in the "Last Lesson" column? I need to be able to check the "Lesson No." against the "Number of Lessons" columns, as well as the clients name group (all unique in the proper version). How can I check to see if the last "Lesson No." cell in each clients group matches, is less than, or is more than the "Number of Lessons" column?
Hope this makes sense! Any help would be greatly appreciated!
Thanks,
J
Hoping this isn't going to pop up multiple times, seem to be having problems posting!
I am working on a schedule tool for tracking training sessions for each of our clients. The final worksheet will be an extremely long list of all clients, lessons, lesson status, and dates.
So far I have created a formulas to automatically handle adjusting the lesson number if a lesson is cancelled. You can see it in action here: https://anglokom.bitrix24.com/~AWuiU
I have two questions:
1. Can anyone see a more elegant way of handling the functions in the "Lesson No." column? I have done it with a large amount of nested IF statements, but it is limited by the number of if statements I have put in there meaning if a client cancels more than about 8 lessons the formula won't work. I could of course add lots more IF statements but I'm wondering if there might be a better way to tackle this?
2. How can I automatically display the appropriate messages in the "Last Lesson" column? I need to be able to check the "Lesson No." against the "Number of Lessons" columns, as well as the clients name group (all unique in the proper version). How can I check to see if the last "Lesson No." cell in each clients group matches, is less than, or is more than the "Number of Lessons" column?
Hope this makes sense! Any help would be greatly appreciated!
Thanks,
J
