Creating a technology device loaning process

mig1980

Good day everyone. I am new to the community but not new to Smartsheet. Have been using at my company for a number of years now.

My team has acquired a quite a few pieces of equipment and it seems that we are constantly loaning them out to other teams for certain periods of time.

I have been working on a loaning process that would revolve around Smartsheet, allowing another team to access a Smartsheet form, complete the required information (i.e. - Device requested (selected form a dropdown), requester's email address, request date (date the device will be needed), and a return date).

I have also setup an approval process for myself and a colleague to be notified and either approve or deny a request.

The only piece I can't figure out (and wasn't successful with receiving assistance from Smartsheet) is how to not allow a device to be selected/selectable from the dropdown (on the form) or not allow the form to be submitted (with a message stating why) if the request date and return date span overlap with another request that has already been approved.

Is this possible? If yes, can someone assist me getting this configured?

Thank you

Shaine Greenwood

Hello,

Conditionally locking/removing the dropdown option currently isn't native functionality in Smartsheet. When you have a moment, please submit a Product Enhancement Request to let our Product team know that you'd like to see this feature added.

You may need to consider creating a report and publishing it so they can check your equipment rental schedule. More on publishing reports here:https://help.smartsheet.com/articles/522078-publishing-smartsheet-items

Otherwise, we have a powerful calendar app that might be able to accomplish this more automatically for you://m.santa-greenland.com/apps/calendar-application

Susie Wachowski

Hi Shaine,

Has this feature been added since the question was posted back in 2018?

Thanks,

Susie

Andrée Starå

Hi@Susie Wachowski

I hope you're well and safe!

Unfortunately, it's not possible now, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

Here's a possible workaround or workarounds

• Using the Premium app, Data Shuttle to "sync" the dropdown lists.

Is that an option?

I hope that helps!

Have a fantastic weekend & Happy New Year!

Best,

Andrée Starå| Workflow Consultant / CEO @WORK BOLD

✅我的帖子(s) help or answer your question or solve your problem? Please support the Community bymarking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!