Interacting with reports error

Hi all,

Running into an issue. So I have 5 depts that will be updating their progress in a lifecycle management of the product I'm tracking. I have created a sheet where I get all the overview and have conditional formatting whenever someone clicks on the checkbox their portion becomes green.

The issue I'm running into is the first dept procurement. They can input the information in the sheet but I have segregated their portion in a report. It seems like unless the new row is created from the sheet with the data it does not let procurement to input new data in a new row.

How do I automatically trigger the next row so procurement can input the data. FYI: once the row is created all the other depts does not have any issues interacting in the reports.

Any help will be appreciated.


Best Answer