Good Afternoon,
My goal is to alternate background colors on a dashboard list using advanced formatting. I can do this by using the modulus operator on the OBJECTID. However, on a majority of my products I prefer to sort my list alphabetically (using a NAME field). Due to the nature of advanced formatting (expressions apply to individual line items), the logic is alluding me.
Is there a way to alternate background colors while my list is sorted alphabetically (not by objectID)? or a built in mechanism for dashboard lists (that im totally missing)?