Last value in a row

Desertbird

Hello,

I have a sheet that is used for taking attendance, with names down the primary column and columns for each day of the week (mon, tues, wed, thurs and fri, etc for following weeks), plus one last column for the current attendance.

I need to pull the most recent value from the days of the week to show the current attendance. Is there a way to do that?

Desertbird

Found a solution here; https://community.smartsheet.com/discussion/29146/how-to-select-value-from-last-column-in-a-range

Desertbird

update: I have tried adding a helper row on top and numbering each of the days with the below formula, but it comes up as incorrect argument.

=index([Monday 1]1:[Friday 4]1,1,max(collect([Monday 1]@row:[Friday 4]@row,@cell<>"")))

Desertbird

Found a solution here; https://community.smartsheet.com/discussion/29146/how-to-select-value-from-last-column-in-a-range