Inventory Management - View Total Stock Available in Souce Data

[cstanley]

I am using the Inventory Management template and I am wondering if there is a way to have the "Total Stock Available" come up as a column heading in the "Items" sheet in the source data spreadsheet and have the value for each item respectively. I would also like it so that the value can be updated either by the app or updating the value in the spreadsheet. I have "show" selected but this does not seem to solve this. Thanks

[lynchk21]

It sounds as if [Total Stock Available] is a virtual column, so it will not be available in your source data spreadsheet. You will need to replace it with a column in your spreadsheet and either use a spreadsheet formula, an app formula, or a bot/action to update it.