Checking for values across multiple columns

I am trying to write a formula that checks for blanks across 4 columns until it finds a value. I have researched this much and have written countless formulas with no luck. Can someone help me out here? Below is what I am trying to achieve.

Best Answer

  • KPH
    KPH ✭✭✭✭✭✭
    edited 02/13/24 Answer ✓

    Is the formula you are looking for the one to populate the Handling Agent column? If so, is there a possibility that two group columns could have a value in. If so, how would you like that to display?

    If you only have one name per row, I think a simple JOIN could do what you want.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!