Calculator Studio | Community

Linking a cell to a different sheet in the same excel workbook [Solved] Community support
Reply
Newcomer 2 posts CIMCO Refrigeration cassandra.dcosta Newcomer 2 posts
CIMCO Refrigeration cassandra.dcosta
Is it possible to link a cell from a particular sheet (say sheet 1) to another sheet (say sheet 2) and for the tool to pick up data from that sheet (sheet 2)? 
For instance, I want different data for every province in Canada. I want the user to select a option from the drop down and as soon as he picks his province I want all the data of that province to populate. Any direction on how i can do that? 
Reply 0 0
Ásþór Aron Þorgrímsson asi GRID Community Manager 116 posts
Ásþór Aron Þorgrímsson asi
Hi @cassandra.dcosta

Yes, you can reference cells between sheets and you can do that simply by entering = into the cell you to reference another cell in another sheet.
Then you open the other sheet and select the cell you want to reference.

For example:
You have Sheet 1 with cell A1 where there is data that you want your cell B1 in Sheet 2 to reference.
Then all you need to do is either enter = and select the cell or enter this code in B1 in Sheet 2: 
='sheet 1'!A1

Here is a GIF that shows how it works in GRID interface:
Screen Recording 2023-03-08 at 10.14.49.gif

 
I hope this helps and have a great day!
Reply 0 0
CIMCO Refrigeration cassandra.dcosta Newcomer 2 posts
CIMCO Refrigeration cassandra.dcosta
So in the calculation that i am using, each province in my drop down will have a different sheet. I want th euser to pick the option from teh drop down and then grid is able to pull all the calculations in that sheet. Is that possible? 
Reply 0 0
Sigurður Óli Árnason sigurduroli GRID Team Member 50 posts
Sigurður Óli Árnason sigurduroli
Hi
You can build the sheet reference dynamically by something like this:
  • Make A1 be the target cell for the dropdown menu (so it contains the name of the sheet selected in the dropdown)
  • Put something like this in cell A2: 
    =A1&"!A:D"
  • Then to get the data from the selected sheet you can use this: 
    =INDIRECT(A2)
If this is confusing or not helpful let me know!
Reply 1 0
Jason R. Escamilla, CFA impact Newcomer 4 posts
Jason R. Escamilla, CFA impact
impressive functionality/compatibility!
Reply 1 0
Reply