im trying to make a formula filled spreadsheet for document review.
I'm about there but now I am getting a #VALUE! on my icon conditioned column.
looking at it, this would be because the =VALUE() formula hasn't got anything to pull through.
Cann you use a =value() else "" or something along those lines to bring back blank if no value instead of an error.