Alok Mishra
New Member
Here is the google sheet link- Copy of WPR - Google Sheets
1- I am not able to fetch data in column P row 6 and onwards. I am trying to create an arrayformula that fetch the data from Backup Data A9:A and but not able to create. I need the data in column P whereever data is there in COlumn J of wpr sheet. formula is there in P6 and P16 for your reference. I need to apply arrayformula in P6.
2- There is problem with the script as well where I am selecting any data in column M, it is giving me dropdown in column N in wpr sheet fetched from backup data sheet but when I am selecting data in bulk, it is not creating the dependent dropdown.
Please help for the both the problems!
1- I am not able to fetch data in column P row 6 and onwards. I am trying to create an arrayformula that fetch the data from Backup Data A9:A and but not able to create. I need the data in column P whereever data is there in COlumn J of wpr sheet. formula is there in P6 and P16 for your reference. I need to apply arrayformula in P6.
2- There is problem with the script as well where I am selecting any data in column M, it is giving me dropdown in column N in wpr sheet fetched from backup data sheet but when I am selecting data in bulk, it is not creating the dependent dropdown.
Please help for the both the problems!