Return 1st, 2nd, and 3rd non-blank value per row


Essentially, I want to create a Master_Supervisor_List and Master_Employee_List. Essentialy my columns go from "Supervisor AH" all the way to "Business Title ZH". I cannot reorganize the columns because the survey is built using logic. The columns repeat in the following order: Supervisor, Employees, Buisness Title.

In otherwords, each row will only ever have 3 values present in the following column range of "Supervisor AH" to "Business Title ZH".

How do I write a formula that would return the Employee present in the row and Supervisor Present in the row?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!