Build a formula

Platform discussions
,
1

Build a formula to return value from dropdown column a or dropdown column b

2

Hi Rebecca,

You’re not giving details of when you should return value from dropdown A or B, but here is an example of get dropdown A if it contains a value and if not get dropdown B.

IF({Dropdown A},{Dropdown A},IF({Dropdown B},{Dropdown B}))

 
 

Want to get rid of the formula column? and write formulas that support multiple lines, variables and can update various columns at once? Take a look at the Advanced Formula Booster at https://mdboosters.com*