Compare two documents

Paula Cosentino

We have two smartsheets:

1. houses the information needed to send a survey (Org Name, Address, email). We send the survey using the form link from the 2nd smartsheet
2. the other smartsheet collects the survey results.

We don't want to have to manually compare smartsheet to see who did and didn't return a survey. Thinking there could be a formula looking to see if an Org Name is already on the second smartsheet.

Any ideas? I've been trying to do an index match, but failing. Maybe even a "check the checkbox" if you find a match??

Thank you in advance for any help.

heyjay

How bout a COUNTIF? Something like,

=IF(
  COUNTIF({Column List},Name@Row) > 0 , 
  "✔" , "X")

heyjay

How bout a COUNTIF? Something like,

=IF(
  COUNTIF({Column List},Name@Row) > 0 , 
  "✔" , "X")

Paula Cosentino

Love this. Thank you for taking the time to help!