Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

sheet/roster

Anna Eddy
Anna Eddy ✭✭
edited 12/09/19 in Archived 2016 Posts

I’ve been tasked w/ creating a sign-in sheet/roster tracking when and how often volunteers are volunteering.  Looking to have either one person manages or have individual volunteers sign-in and mark off.  Would like fields:  Full Name, Function, Date, Time-In and Time-Out – and have the ability to sort by volunteer name or function.  Can I do in Smartsheet? Thank you and Happy New!



  • JamesR
    JamesR ✭✭✭✭✭✭


    Yes this would be ideal for smartsheet with the following caviate.

    The only column that shows a tinme eliment is the create (system Field) therefore  you would need a time column set up using a text/number field with a dropdown showing time slots.


    The users could then have a link to the smartsheet form fo logging in and a link to thier report to show thier entries which they could then add there time out too when leaving.


  • Gwyneth C
    Gwyneth C ✭✭✭✭✭✭

    Thanks James for the workaround about how to have people specify times.


    @Anna, if you'd like a bit more information about how to create and work with Web Forms in Smartsheet, we have an article and video in our Help center:


    Here's a bit more about creating forms:






This discussion has been closed.