Hello Community.
Its probably simpler than I am thinking, but I have about 26 fields (columns) that I would like to group. The results in each of these fields can only be a choice of three results, Approved, Awaiting Approval, No Applicable.
I will then map these out based on another field which has a variety of products and will determine if it is applicable across those products.
My end result would be:
Approved = X
Awaiting Approval = W
Not Applicable = N/A
Simple, right?