To piggy back off this thead I used a similar formula to format on my worksheet for bipart doors , though one issue Im running into the formula doesn't keep the dimension formating. Is there an additional line of code I need to add or is this a limitation of worksheets?
=IF(Door.config='Swing Bi-Part', CONCAT('(2)', 'Door'.'DoorWidth'/2), 'Door'.'DoorWidth')