Last colored text value in a column


I am in need of a sheet summary formula that finds the last "red" colored value in a column. Another answer led me to this formula which finds the last value of a column. Not sure how to work in the "red" text criteria.

Thank you in advance.

=INDEX([Schedule Attainment]:[Schedule Attainment], COUNT([Schedule Attainment]:[Schedule Attainment]) + 1)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!