We have to 2 Project types and one Budget tracker,

Yashtkr

We need to configure if PO Number entered in the Budget Tracker should pick up the Project details of 2 Project Tupes based on the PO number existed in Project types sheets and the PO number existed in Project types has multiple PO number existed in single cell. Can anyone help.

Budget Tracker shown below

Matt Lynn-PCG

@Yashtkr I'm not 100% sure what you're looking for but it seems like you're asking how to count the number of project types a single PO # has? IF so you could prob do some kind of count(distinct(collect())) formula to count the distinct differences within a collection of results by the PO #.