How to select value from last column in a range
Would love to get feedback on how to create a "Current Status" formula that looks by row across columns to pull the latest value. What I want is a formula that updates automatically as I populate columns with weekly Account Status.
Below is a screenshot that shows the columns I am working with. The leftmost column is the Current Status column I am trying to populate. It would look across both populated and un-populated columns to the right. The goal is to capture the rightmost column that has a populated Account status.
Help Article Resources
Check out the Formula Handbook template!