I have a table in a base with 12 fields, all Single selects with the same options in all fields.
In field 13 I would like to display a ”status” based on the various options selected in field 1-12.
As an example I belive an actual Airtable-table shows better what I want than me trying to explain it:
My thinking was to use an IF-formula within an IF-formula within an IF-formula etc. etc., but I couldn´t really get that to work.
Any other way this could be solved better?
Thanks in advance!