We keep client data, like hourly rates, on a central "source of truth" list. Other lists connect to it through relationships and use rollups to pull in the data they need.

Rollup values seemingly can't be used in formula fields. For example, we can roll up a client's hourly rate into a task list, but we can't multiply it by tracked time in that list.

This comes up in several places across our workspace. Right now the fix is copying values into each list by hand (or with an agent) and keeping them updated.

We'd love rollup values to work in formulas!