Training Registration - Specific date for each department

Options

I need to create a training registration form wherein I would like registrants from each department to select the same date. Each department gets a date. I have already thought about having a liaison choose a preferable date for the department, but I would like to know if there are any other ideas out there on how this can be done. I would appreciate if you could share your thoughts or ideas. Thanks!

Answers

  • Wilen FL
    Wilen FL ✭✭✭✭
    Options

    @Asha Krishnan

    Please provide additional details to help determine your objective. How many departments? How many dates are available? Is the goal to have X departments and X dates and once a date is selected it is no longer available? And then once selected that date is automatically assigned to everyone else in that department? How versed are you with automation and formulas?

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Options

    Hi @Asha Krishnan

    I hope you're well and safe!

    Have you explored using Update Requests instead?

    Would that work/help?

    I hope that helps!

    Be safe, and have a fantastic week!

    Best,

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

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Asha Krishnan
    Asha Krishnan ✭✭✭✭
    Options

    @Wilen FL Thank you for your response! I do not really have all the specifics (number of departments and the list of training dates) that you are looking for at this time. The goal is to have all the employees from a department attend the training on the same date. If we follow the "once a date is selected it is no longer available" approach, I understand that I can use the automation to notify me that the date has been selected and manually remove it from the drop-down list and use a formula in the sheet to apply the date to all the registrants who select the same department. But how would the registrants other than the first know when the training has been scheduled for their department? How would you suggest that I make the registrants aware of the training date using your approach?

  • Asha Krishnan
    Asha Krishnan ✭✭✭✭
    Options

    @Andrée Starå Thank you for your response! How can we make use of the Update Requests in this case? Can Smartsheet populate drop-down options in the next question (Training Date) based on what was selected in the previous question (Department)?

  • Wilen FL
    Wilen FL ✭✭✭✭
    edited 10/15/22
    Options

    @Asha Krishnan

    To your point, this sounds like it would need to be a multiple-step process. The first, to your example, would be to define and assign the dates to the registrants of each department. Second, create a workflow that triggers when the 'Date' field is 'Any Value' (see screenshot below).

    Customize the message to include the column header field(s) in double brackets {{}}.

    Example:

    {{Registrant}}, your scheduled training date is {{Date}}.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!