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?
But we are still missing the query fields in Calculated Fields.
For example: we have a currency field on Bookings (Crew Planning), so on the Project we created a Query Field that makes the Sum of all Bookings. But from there we cannot calculate anything else from that field…