Return the last text value from a multi-column search

I have 5 columns from left to right: 'Site 1', 'Site 2', 'Site 3', 'Site 4', 'Site 5'.

I am looking to search each column by row to see if there is a value entered into each site column. If a value is entered, I'd like to return the last site that has a value into a new column labeled 'Latest Site' (e.g. Site 1 and 2 have values so then the Latest Site column returns the value from Site 2).

The site columns would be text fields. Below is an example of what should happen. Could you help with a formula that could be used in the Latest Site column?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!