Lookup on a form?

Hi all,

Is there a way to have a date/time field on a form look up data in a separate sheet to populate itself?

I'm setting up a form for people to select a date and time slot to attend a training session. I thought about having the list in a separate sheet and then only show on the form dropdown the sessions that are still available.

Is there a way to do this with Smarthseet?

Thank you in advance!

Find more posts tagged with

Forms

Human Resources

Calendar View

Formulas

Government

Cell linking

Comments

Andrée Starå

Hi Anelise,

Unfortunately, it's not possible at the moment, but it's a great idea!

Please submit an Enhancement Request when you have a moment.

A possible workaround could be to use a dashboard with the sheet on one side and the form on the other to be able to see the information at the same time.

Would that work?

Have a fantastic week & Happy Holidays!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Anelise Wilhelm

Thank you! I'll give it a try.

Paul Newcome

I actually use Andree's suggestion, and it works well and has received a lot of positive feedback.

Andrée Starå

Happy to help!

Best,

Andrée

Anelise Wilhelm

How do you know when the capacity (15 people) per session has been reached and then automatically remove that slot from the offering sheet?

Paul Newcome

I have notifications set up to alert me when we get close to and then reach capacity. I then have to go in and manually remove it.

For larger projects, I have a list that collects available dates. If someone requests an unavailable date, I have an update request automatically sent out that shows them the list and asks them to pick a new date from the available dates/times.

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…