Automatically add people in Contacts column depending on the Country

Hello everyone,

My team has a sheet with Submitter, Country, Recommendation columns. Each Recommendation is related to a Country. According to the Country, the Submitter field would have to be automatically filled with the respective people for the specific country.

The Recommendations are added through a form.

In addition, all Users should be able to View ALL Recommendations, and Edit ONLY the Recommendations of their Country.

Also, we don't want to provide access to the users to the Sheet, so we would like to use Reports for this implementation.

One implementation would be to create one Report for each Country for Editing purposes, where only the users of this country will have access to. However this would create many Reports and we would like to avoid that.

Is there a way to implement this, taking into consideration all the above requirements?

Thank you in advance!

Answers