Are these possible?
For example, in our current Excel door schedule, we have a column titled 'Leaf Details.' If a door is to be retained, the column will read 'Ex door retained', and if it's a new door, the column will read the leaf dimensions. Is it possible to tell the scheduler:
IF door is on 'As Existing' Layer then 'Leaf Details' = 'Ex door retained'
ELSE 'Leaf Details' = leaf size
