Question on How to Integrate a Form

Hillary Valor

We have a sheet that tracks our inventory. We want to build a form for people to input a pickup request of certain inventory items to be moved between places. Is it possible for the Form to reference the Inventory sheet to see if the Quantity requested for pickup is available?

For example The form would ask for an item number and description and quantity of the item that needs to be picked up. I want the form to then reference the same item number on another sheet and verify the quantity needed is available.

Can Smartsheets do this? How would I set this up?

thank you for your help.

Bassam Khalil

Hi @Hillary Valor,

Hope you are fine, you can't see the result of the calculation in the form because no formula will work in the form until you submit your request, but you can solve that in a different way:

1- you can add a report with a filter that shows the available amount of each material.

2- you can design an update request workflow that sends the request for the person who submits the request show him the available amount if his request is over the balance.( i prefer this option )