Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Count the number of projects in a folder
Our team is looking for a way to count the number of projects of three distinct types. I have them located within three different folders. I do not want to have to use cell linking. A user should be able to create a new project without having to open a summary sheet and create a new cell link. If I could use a formula in a report life would be good - can't be done. If I could do a sheet to sheet formula - this would help - can't be done. While creating a new sheet a cell link would automatically be created to a destination summary sheet - I don't think this can be done. I am trying to make this as seamless as possible for our end users. I have created many workarounds for other issues but this one has me stumped. Our management team wants to know how many projects we have open in each category.