Format Rules with multiple icons

[1minManager]

I have 2 columns we’ll call [part1] and [part2]. Both are an ENUM with options of ,Ordered, Arrived

I’m trying to get an App so that its puts 2 different icons next to the job number column, each having a separate colour code depending on the status of [part1] and [part2]. The problem I’m having is that even if [part1] and [part2] are totally different the two coloured icons are always the same colour.

Any ideas?

[Jonathon · Accepted solution]

Unfortunately AppSheet will only allow 1 formatted color option per column. The only workaround I am aware of is to separate the formatting rules across multiple columns.