Pre Populated Form Fields

Mike Couture

I want to create an order request form with an inventory control sheet I've created.

The sheet contains remaining stock on hand of several different items.

The drop down list will contain the items I have in stock, but I'd like to have the amount available to show up based on the item selected.

This number would be available in a cell in the worksheet.

Any thoughts?

 

Thanks

Mike

Mick Jordan

Hi Mike, any kind of real-time calculation on the form itself isn't possible currently as far as I am aware.   We have automated this kind of thing in the past by building clients an App with a desktop form using the Smartsheet API.

Mick

Mike Couture

Thanks Mick, I suspected that was the case.

We'll stick with user intervention.

Mike