IF statement - How to return a result from two multiple sources

Options

I was wondering if there is a way to do an IF statement to capture a result and add that result into another cell?

eg. from A1 (if C2 =“NSW” return “abc computers’ in B2)

note - I can’t put the formula in B2 as this a drop down list.

the only other alternative would be conditional formatting but smart sheets only gives font/colour options, unless I’m missing something.

Any suggestions?

Regards

Daniel

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!