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? 😓
Help Article Resources
Check out the Formula Handbook template!