Best way to carry out teams audit and monitor progress

Hi, Smartsheet community,

I am new to smartsheet and have been tasked with a project to conduct an "as-is" process audit. at least 20 functional teams will be involved in this process.

Because the teams have different functions, I'll like to give them the flexibility to duplicate all questions around each activity they carry out. I'll like to:

  • Create a dashboard to monitor the progress of the audit
  • Send a unique link to each team to complete the audit
  • Be able to see the data that has already been entered
  • Create reports
  • Be able to analyse the data later.