At the moment, shotgun can’t use query fields in calculated fields.
You also can’t use linked fields in calculated fields, which is a massive obstacle for us in a lot of cases.
We can make duct-tape solutions using the API, but has anyone found a way to get around this with general use of the UI in shotgun?