Recent Submission Formula
My goal is to create a formula that will automatically update the current status of our utility systems based on the submission of the most recent inspection form.
Basically, I'm looking to create a green dot on a separate sheet if ARU1 and ARU2 are both online and both temperatures are in spec (I can provide the temp range if needed). Yellow Dot if both temps are in spec and one or both ARU1 and 2 are not in auto. And finally, red dot if either temp is out of spec regardless of ARU1 and ARU2 status.
A formula conveying the same information for only ARU1 or ARU2 with their respective room temperatures would be adequate as well.
I attempted a Max Collect function but was receiving numerous errors.
Any help would be greatly appreciated!