Is it possible to do math with data tags?
A Data tag reads the door rough opening width 1100.
The number 1100 is divided by 100, leaving 11. Letter M is added, thus final text on the tag would be "11M“.
This is just one example, I can think of many others uses as well.
Now I have a nice data tag displaying the door size automatically, thank you all!
The only thing missing is: How to read the handedness of the door automatically? Anyone know if this is possible? With worksheets I've looked into a combination of IsFlipped and rotation and IF formulas, but so far no solution for all situations.
If we could solve this last bit, then there would be no need for manual size and handedness input any longer, eliminating the possibility of erro