I need to show most recent row on a dashboard
I am trying to figure out he MAX(COLLECT and INDEX formulas. I have an input sheet for 8 seperate facilities and want to show the most recent status for each facility in a dashboard. I have been trying to figure out the I am trying to figure out he MAX(COLLECT and INDEX formulas but I am currently failing lol.
I want to show Treatment Plant Satus and Description of Status any help would be greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!