Data Validation Across Sheets

Don Beck ✭✭

01/26/21 in Formulas and Functions

Trying to do a Data Validation across two sheets to create a drop-down list in a cell.

Is this possible?

Thanks

Don

0 · Share on FacebookShare on Twitter

Best Answer

• 

  Bassam Khalil ✭✭✭✭✭✭

  01/27/21 Answer ✓

  Hi @Don Beck

  Hope you are fine, i don't think this can be done now you can submit an Enhancement Request to help smartsheet developer team to do it in future

  PMP Certified

  bassam.khalil2009@gmail.com

  ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  0 · Share on FacebookShare on Twitter

Answers

• 

  Bassam Khalil ✭✭✭✭✭✭

  01/27/21 Answer ✓

  Hi @Don Beck

  Hope you are fine, i don't think this can be done now you can submit an Enhancement Request to help smartsheet developer team to do it in future

  PMP Certified

  bassam.khalil2009@gmail.com

  ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  0 · Share on FacebookShare on Twitter
• 

  Hannah_Trousdale45 ✭✭

  01/15/25

  @Bassam Khalil Is this possible now in 2025? I would like to have one master sheet and several target sheets that have a drop-down list offering updated data from the master.

  1 · Share on FacebookShare on Twitter

Sign in

Try Smartsheet

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list