Summarized morning checklists?

My program has three morning checklists that are completed on a daily basis to ensure systems are working properly. I currently have a sheet built for each checklist with a form feeding each one. I want a report to be triggered when all three checklists are submitted and for that to be sent to a specific person. Each sheet has different columns but are either Yes/No answers or free form text. What's the best way to generate a consolidated report that's triggered to initiate an email only when all three checklists are submitted?

Ideally, the report summarizes the sheets and only indicates the free form text AND/OR if a question is answered "No."

Tags:

Answers

  • NicoLHC
    NicoLHC ✭✭✭✭✭✭

    @dsguttormson its a pleasure to meet you ! I think i would use a 2 workflows.

    1. if new form submitted copy the info to a helper sheet.
    2. from the helper sheet if 3 reports today then inform person.

    If my comment helps you, I appreciate a πŸ’‘

    Kind regards

    Nico | LinkedIn

    CEO | Lighthouse Consultings

    Lecturer in Business Information Systems | DHBW

    ________________________________________________________________________________

    addvalue@lighthouseconsultings.com

    We offer Licenses - Training - Solution Engineering

    πŸ”΄ GOLD Smartsheet Partner _______________________________________________

    πŸ’― SCALEABLE Solutions Engineered by Lighthouse Consultings

    We Don’t Just Implement Smartsheet; We Revolutionize How You Manage, Plan, And Execute.

    πŸŽ₯ YouTube πŸš€TimeLine View

    http://lighthouseconsultings.de/