Lookup in one column to enter text in another

MHuggs
MHuggs ✭✭✭

I want to look up a value from a dropdown in one column and enter text into another column based on the value found in the first column - is this possible? I can't seem to work it out!

For example, if 'Column A' is '123', 'Column B' will populate with the text 'Great'. Again, if 'Column A' is '456', 'Column B' will populate with the text 'Not bad'.

Anyone got any ideas?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!