How to reference cells in other views?

Is there a way to reference a cell in another view and pull that data into the current view?

Hi @chrisbrownridge,

Great to see your first post on the forum!

Yep, you can reference a cell from another view.

Referencing the A1 cell from View2:

=‘View2’!A1

Applying a formula (SUM) to a range A1:B10 cell from View2:

=SUM(‘View2’!A1:B10)

Referencing the A1 cell from a long view name that with spaces:

=‘View with spaces’!A1

This should do the trick.

Hope it helps!

1 Like