Last colored text value in a column

Kim Ryan

Hi,

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)

Mike TV

@Kim Ryan

There isn't currently a criteria solution for text font color. That would be an enhancement request which you can submit here:

https://app.smartsheet.com/b/form/739aa75f30ca43a8a22eb53e4da7d409?Origin=help&_gl=1*1n7j62x*_ga*MTMwNTM3MDg3LjE2NDg4NTkxMzY.*_ga_ZYH7XNXMZK*MTY2Mjc2Mzc2MC40NC4xLjE2NjI3NjM5OTMuMTEuMC4w&_ga=2.18222393.145694658.1662677407-130537087.1648859136

However if you have the cell formatted with a red font color using Conditional Formatting, then depending on what criteria you used to do that it could be repeatable in a formula. Are you using Conditional Formatting for your red color? If so, can you share those settings?