Formula to pull the non-blank value from multiple columns


Not sure if this is possible but I'm trying to pull a non-blank value from one of multiple columns and paste it in a separate column. Essentially, there are 5 columns that are Department (Deburr, Lathe, Mill), Deburr Machine, Lathe Machine, Mill Machine, and machine (think of this column as the master column, or combination of all machines). In a form with conditional logic, the Department is selected and then displays the available values for the chosen machine. For the example, Deburr can only have value A, Lathe can only have B, Mill can only have C (achieved via single select dropdown). From here, the value of the chosen machine is selected and the two other machines are left blank or can be set to something like NULL or BLANK via automation if needed.

What I'm trying to achieve is pasting the value chosen under the Deburr/Lathe/Mill Machine columns into the master machine column. I've attached a picture below that shows how the sheet would work. I've tried some COUNTIF formulas but I can't seem to get it to work. Is this possible or should I abandon this idea?

Thanks for the help!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!