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

WorkforceAnalystOSDH

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?

Eric Law

https://community.smartsheet.com/discussion/114461/return-1st-2nd-and-3rd-non-blank-value-per-row

Good news, your column order does not affect your form, so feel free to rearrange it to an easier format on the sheet end! That means... group your Supervisors, Employees, and Business together and your formula will be so much easier!

Then you will just need =JOIN(COLLECT([First Column Name]@row:[Last Column Name]@row,[First Column Name]@row:[Last Column Name]@row, NOT(ISBLANK(@cell))),", ")