Changing Row Status
My ultimate goal is to capture the "latest" entry from each row. This information will feed into another sheet/Dashboard.
The column names are shown as dates Jan 7, Jan 14, Jan 21 etc... but, are formatted as text/number columns (not date columns).
With that being said, Is there a way to automatically change a specific cell in the status column ex: ryg ball, according to the latest entry which will always be, furthest to the right?
Hopefully this makes sense.