Help on referencing a sheet in a formula

Hi - this is the first time I'm trying to reference a sheet in a formula. The formula is =COUNTIFS(TA:TA, CONTAINS("SC/SE", @cell)) . When I reference the sheet in the formula, I get =COUNTIFS({Project Status Range 1}) . My question is how do I integrate =COUNTIFS(TA:TA, CONTAINS("SC/SE", @cell)) into =COUNTIFS({Project Status Range 1})? I've tried a quite a few ways and none of them work. Your help is appreciated!

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!