Link from a cell-reference and make the answer a column formula

Annaleah Morrow

When we set up a sheet we did not add an 'industry' column. I can link to a metadata sheet to get that information and link it to a single cell on my sheet . . . however, I need to have that value appear on every line of a column (so that reports across with the info across industries can be sliced differently). I created a helper column to bring in the cell thinking I could create a column formula to always bring back the absolute value of that cell, but you can't make a column formula from an absolute.

I am open to other ideas. I know I can create an automation, but ideally I would like to use a formula so that I can add the new column and formula at my blueprint level and not have to touch each active project after we push it out through control center.

Ideas?

Corey W.

What if you put the link to the Industry value in the sheet summary. Then made your column formula reference the sheet summary?