Cell-linking work around

Is there anyway for me to use a formula that when the value selected in a multi-select column is "Admin", then give me all the values from the "Baseline Start Date" ?


I want the values (dates) to come back to my sheet lined up as their own cells/rows (vertically placed) in a column that i want.


Similar to how you would do the cell-linking? When i select multiple cells, link from other sheet, the select multiple cells again, then it comes back as is.


Thank you!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!