Hi @Khadija Ali

Please try the following:

use the COUNTIFS function to check if the project ID in Sheet 2 matches any project ID in Sheet 1 and if there's any entry under the feedback-related columns. Here’s an example formula you can use in Sheet 2:

=IF(COUNTIFS({Sheet1 Project ID Range}, [Project ID]@row) > 0, 1, 0)

In this formula:

• {Sheet1 Project ID Range} should be replaced with the range of the "Project ID" column in Sheet 1.
• [Project ID]@row refers to the Project ID on the current row of Sheet 2.

This formula checks if there are any rows in Sheet 1 that have the same Project ID as the current row in Sheet 2. If at least one match is found, it returns 1 (which will check the box), otherwise, it returns 0 (which will leave the box unchecked).

The formula provided above inherently handles multiple feedbacks per project without returning a BOOLEAN error. The COUNTIFS function counts the number of times the specified condition is met across the dataset. As long as there's at least one feedback for a project, the checkbox will be checked, regardless of the number of feedback entries. This approach doesn't throw a BOOLEAN error because it's always returning a numeric count, and the IF function then converts this count into a checkbox state (checked or unchecked).