Referencing Another Sheet

I got the following formula to work:


However, now I need to understand how to have this work if its not the same sheet I'm currently referencing.


So my sheet I'm referencing can be called "TEST" for this example. I need the same formula to work but how do I reference that other sheet?

=COUNTIFS({TEST Range 1}).


Range once populates when I select "Reference another sheet" and then select the column. Range 1 is actually the column "Status" from my working formula.


Thanks

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!