Counting completion status off of a group of sheets


We started a new process for course development that has tracking development of each of our courses in separate sheets. 1 course per sheet. Its easy to pull a report of how many of those courses are now in a complete status but I am trying to figure out how to pull together a dynamic number for the total number of courses in that report. Or, depending on how you look at it, the total number of completed courses from each of those individual sheets. Is there a way in smartsheet to do this easily? Recommendations? I don't want to build out a thousand cross sheet references for each individual sheet. There has to be a way a to do this that I am not thinking about? 😓

Best Answer


  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    That is a great idea. Thank you. The copy row automation makes a TON of sense. We'll implement that right away.

  • Genevieve P.
    Genevieve P. Employee Admin

    Great!! Glad I could help :)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!