79523669

Date: 2025-03-20 17:17:37
Score: 0.5
Natty:
Report link

I was not able to use IMPORTRANGE as a data validation as PatrickdC clarified.

I was able to do the following:

  1. Create a Google Sheet (call it Sheet A) that has all employees in our organization.

  2. From my other Sheet (call this Sheet B) I then did an IMPORTRANGE in the sheet cells rather than in data validation. This brings in all the data from my Sheet A. I then created another tabbed sheet on Sheet B and I was able to use the imported data on the other tab of Sheet B to then do an IMPORT for data validation.

Reasons:
  • Long answer (-0.5):
  • No code block (0.5):
  • Self-answer (0.5):
Posted by: David Pugh