I’m working on two separate base for my organization: the first manages the order, and the second the tracking and payment process.
With the sync tables I’m able to get the tables from the order in the second base for the planning and processing of the shipment and payments .
But I’m encountering a problem: there are some lookup fields about quantities that I need to process as number on the second base. The synced table show them as text, so the lookup on the tracking table it is also showing them as text, but I can’t modify the format to a number. I’ve also already tried to add another field with a VALUE() formula, but it gives an #ERROR! and doesn’t evaluate the text into a number.
Any idea how to proceed?