RGYB status - Return value based on blank cells in row

I have a table where we have to report the status of a task for each month as the year progresses, so there is a column for each month and an overall status column (see image). We're using RGYB symbols to reflect these statuses. I'm having trouble figuring out the formula to pull the status of the latest month reported. For example, in row 3 in my image, the overall status should return a value of the blue symbol. Whereas, in row 4, the overall status would show a green symbol since nothing has been reported for Jun-Dec yet.

Any advice on how to achieve this?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!