Function Help - Sheet References

jay.rathbun
jay.rathbun ✭✭
edited 12/09/19 in Formulas and Functions

Hi there - 

I am working on building a slightly better project tracker for our organization. We currently utilize calculated fields that we have to define for each new project, and sometimes the project does not have enough project rows to account for all items we are tracking. 

I need help with a specific formula that would reference values from another sheet. My current formula when the data is embedded in the same sheet is:

=COUNTIF(CHILDREN([Project Type]:[Project Type]), "Process Improvement")

I would like to pull these calculations into their own sheet, so what I am hoping to learn how to do is essentially:

=COUNTIF(CHILDREN({External Sheet}[Project Type]:{External Sheet}[Project Type]), "Process Improvement")

I cannot figure out how to do this with the documentation i have looked at. Any help would be greatly appreciated!

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!