Interactive form

Currently I am having a form to collect the timesheet information from different 3rd party vendor. After receiving the data, I am creating a Timesheet smartsheet.

I have another master smartsheet which is the collection of all the purchase orders and keeping track of present status of the amount consumed.

Is it possible to make the first form interactive. like when the amount consumed is greater than the maximum allowed amount, the vendor will not be able to select that particular PO to submit the form.

If you see the attached figure, PO Number 4900675165 with line number 2 is not allowed to book further since all the amount is already consumed where as we are still able to book under 4900675165 with line number 3.

Thanks for the help.

Answers