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.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!