I am having an issue scheduling plumbing fixtures. I am trying to sort out items that have a plumbing parameter associated to a piece of equipment and filter out the ones that don't. My issue is that some equipment has cold water some have hot water and to make matters worse some have Gas. I have tried various things to combine them even add a calculated parameter to add all the sizes to one so I can just filter that. (For example) cold water size = 1/2" and Hot water Size = 1/2", so my calculated comes out to 1" sweet. now lets add the gas to it cold water size = 1/2" and Hot water Size = 1/2", Gas size = 1" that is when it goes blanc . It doesn't make sense since they are all pipe sizes.

P.S. also tried formulas but it errors on Exists
(if(Cold Water Size >0”, “Exists”,(if(Hot Water Size>0”, “Exists”,(if(FILTERED WATER SIZE >0”, “Exists”,(if(Direct Waste Size >0”, Exists”,(if(Indirect Waste Size >0”, “Exists”,(if(Gas Size >0”, “Exists”, ))))))))))))

Thanks in advance hitting my head to the wall on this one lol