Struggling with something with computed field

[sumgii]

Part of my App deals with OKRs (think nested objectives). Each child objective has a “Confidence” rating : On-track, At-Risk, Completed etc. Note: Child and Parent are different tables.

I am trying to show the overall confidence of the parent. This is currently based on just being the worst confidence of any child.

I thoughts I was getting there (although seemed to need more fields than I thought), but am stuck at the last hurdle. Can anyone here set me on a better path? This is what I have:

New Field A “Lowest confidence child” on Parent table
Query field. Source = Child table. Filter where Parent=this row. Sort by lowest confidence. Limit to one row.
This seems to be successfully selecting the lowest confidence child item.

New Field B"Lowest confidence" on Parent table
Lookup field. Select the confidence label from the child item returned by the previous field.
This is returning the expected results, but some will be blank (as some parents have not had children added yet".

I then wanted to add an if/then/else that said was effectively:
if A is set return B otherwise return “Not set”. However I cannot select B as a value. It just does not appear on the list.

Edit : I can’t select either of these new fields to appear in lists either (despite them appearing when I show the data table).

Any thoughts?

[Jeff_Hager]

Replace the Lookup column with a Single Value column. Lookups on top of a query will always return an array. Arrays cannot be used in places that only accept a single value. Thus replacing the Lookup with a Single Value will give you a usable single value.

[sumgii]

Dammit, this stuff is so easy one you get involved! Thanks Jeff.

I’m going to put an afternoon in the diary just to go through all the column types and understand the nuances. That often seems to be my Achilles heal with Glide.