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


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?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!