Is it possible to reference another sheet's dropdown list in a formula?


I'm working on a formula to reference another sheet, where the other sheet includes various dropdown menu columns. I want the formula to include an IF statement where, when a cell is selected in the sheet, it populates a corresponding dropdown menu from another sheet. I completed the formula, but the dropdown menu does not appear based on a selection as planned.

I saw similar posts referencing Data Shuttle - is that required to do what I'm attempting?

Any help is greatly appreciated!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!