If all your formula property is doing is passing the values of the SpaceObjects:Room_Number property, you have several options:
1. Why not just use the original property?
Assuming that you have good reason not to use the original property:
2. If the formula property value still needs to be an integer, but you want the zero padding, apply the same Property Data Format that you use for the SpaceObjects:Room_Number property to the room_id formula property. You can also create a new Property Data Format or modify the one you are already using for the formula property and change the zero padding to three decimal places. Zero padding of integers is handled by Property Data Formats.
3. If the formula property value can be text, you could enclose the property reference in the formula property with double quotation marks: "[SpaceObjects:Room_Number]". That should preserve the zero padding, but you will not be able to do math with the results of the formula property.
It was necessary to borrow the value (in this case the room value specifically from that table). The issue is, we generated the BIM with 2 number fields. One number is from the construction documents (design drawings) and the other number is taken from the field condition, in this case the actual number on the door.
I tried the quotations and it work just fine. I thank you for your help.