Allow a column formula to be from a fixed cell

Annaleah Morrow

We regularly need to repeat one value (like 'industry') to appear on each row of our sheets so that when we pull data together we can slice and dice more easily. These are often hidden columns so they don't annoy our clients. The challenge is that we would like to take the singular reference of 'industry' from our project intake or metadata sheet, and you cannot make a column reference refer to a frozen cell. Please consider lifting that restriction to allow us better reporting capabilities.