basic formula to auto-populate one cell based on selection in another cell
Hello - Hopefully an easy question, I just have a mental block when it comes to the formulas. I have a "Location" column with six options (single select). I have another column, "Representative" that has 4 selections. I would like the Representative column to auto populate based on what is selected in the Location column.
For instance; if Portland or Seattle are selected in the Location column, then I want "Rob" to auto-populate in the Representative column. If Boise is selected I want Sarah to auto-populate.
I thought maybe IF or INDEX might be the way to go, but I keep getting the unparseable message (which is pretty standard for me and Smartsheet formulas :). Any help or examples would be greatly appreciated!
All the best,
Help Article Resources
Check out the Formula Handbook template!