Employee Fit Testing Tracking

01/13/22
Answered - Pending Review

I am very new to creating my own smart sheets, I am looking to create a tracking of Employee Respirator Fit Testing. This sheet would need a away to annually updated by testing completion date as well as the type of mask they tested on, noting that some employees with have to complete fit testing on multiple masks each of which will have to be tested on an annual basis. I am at a complete loss as to how to make this happen. Any help would be appreciated.

Thanks

Answers

  • Paul HPaul H ✭✭✭✭

    First option if they always test all types of masks on the same day. A name column, a Multiselect dropdown for Mask types, and a date of test column.

    Second option for test on different dates is to have the employee name column, and multiple date columns named for each type of mask.

    Create an automatic workflow to send a notice whenever a data is 12 months old

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

    Hi @Geard Ledet

    I hope you're well and safe!

    This might help!

    Did 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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Ended up going a different route all together, but thanks for your help!!

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

    @Geard Ledet

    Happy to help!

    Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Sign In or Register to comment.