Compare two documents


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.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!