Is there a way to restrict duplicate value input from dropdown in a Column?

Shrestha

Hello Experts,

I have a lease document with list of gears. This a record of what is on lease. Once a gear is on lease, we cannot lease that gear to another person until it is returned. So I will have to select different gear from the dropdown for next lease.

Is it possible to restrict duplicate value selection form the dropdown in one column?

In this case, Kit-01 is already on lease, so drop down option Kit-01 should be disabled, invisible or restricted.

Please help.

Thank you!!

Bassam Khalil

Hi @Shrestha

Sorry for the delay, please find in the following the solution for your question:

1- Create "Gears Database" with a Lease request form to select the Gears

the formula to check Gears lease status Lease =IF((-1 + [Lease Out]@row - [Lease In]@row) <= -1, "Green", "Red")

2- Create a Summary sheet to check the status of the gears

the formula to check the status =IF(COUNTIFS({Gears Database Lease}, "Red", {Gears Database Assest}, [Assigned Asset ID]@row) = 0, "Green", "Red")

3- prepare a report showing available gears

Bassam Khalil

Hi @Shrestha

Hope you are fine, As i Know you can't do it in the dropdown menu, but you can solve this issue by adding a helper column to give you the status of the gears if it's on lease, and if you like you can add a report show the client a list of available gears to select from in dashboard. 

Shrestha

Hello @Bassam.M Khalil ,

Thank you for your help. Is it possible for you to provide how to do this, please?

How to "select available gears from in dashboard"?

Thank you.

Bassam Khalil

Hi @Shrestha

Ok i will prepare a sample for you

Bassam Khalil

Hi @Shrestha

Sorry for the delay, please find in the following the solution for your question:

1- Create "Gears Database" with a Lease request form to select the Gears

the formula to check Gears lease status Lease =IF((-1 + [Lease Out]@row - [Lease In]@row) <= -1, "Green", "Red")

2- Create a Summary sheet to check the status of the gears

the formula to check the status =IF(COUNTIFS({Gears Database Lease}, "Red", {Gears Database Assest}, [Assigned Asset ID]@row) = 0, "Green", "Red")

3- prepare a report showing available gears

Bassam Khalil

Hi @Shrestha

I hope you are satisfied with my solution, could you please accept my answer to help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Shrestha

Thank you @Bassam.M Khalil for your help.

This is not the exact solution I was looking for but is a good alternative for my workflow.

I appreciate your help.

Best regards,

Sugandha