I have 3 transaction tables which link up with each other associativity based on a mapping table. I have attached the spreadsheet which contains the transaction tables and the mapping table.
My problem is that i am not able to create a common calendar for the dates present in the transaction tables. I saw a few solutions on the community but still unsuccessful in implementing those in my scenario. Please let me know if there is any confusion in understanding this scenario, i will try to create an app.
Any kind of help and advise will be appreciated. Thanks!
Arpit, did Arthur's post with his sample app get you what you needed? If so, do not forget to come back to the thread and use the Accept as Solution button on his post to give him credit and let others know this worked. If you are will working on things, leave an update.
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.