Dynamically populate column values from one sheet to another with conditions

Laurie Mason
Laurie Mason ✭✭✭✭
edited 02/09/23 in Formulas and Functions

Hi all,

I am trying to populate a column of project codes from the Master Project List to a metric sheet. All the project codes are unique, but from what I have read, to keep it updating dynamically I have to have a Unique number (primary column). I was able to get this to work with this formula:

=IFERROR(INDEX(DISTINCT({Master Project List - Project Code}), [Primary Column]@row), "")

However, there are almost 800 project codes. I'm already having a problem with too many cross-Sheet references on the Metrics sheet. So, I only want the ones that are marked as Active. I tried the formula below, but can't get it to work.

=IF({Master Project List - Active} "Active", INDEX(DISTINCT({Master Project List - Project Code}), [Primary Column]@row), "")

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!