Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Hello everyone,
I would like to reference multiple cells in the same column from sheet B onto sheet A. I thought I could create a reference formula on Sheet A to pull the value from sheet B and then drag that same formula down onto the rest of the cells but noticed that the formula does not change if it is dragged. Is there a way to achieve this? (I have to pull the values from one column in Sheet B onto Sheet A and it is 1000+ cells) Please assist.
Thank you!
Why do you need to drag the formula?
Are you trying to refer to a specific range and that range changes depending on which cell is 'asking'?
Can you post the formula you are trying to drag?
Craig
Hello,
I would like to clarify and say that I am only referencing from Sheet B (sorry for the confusion, there is no formula). I need a whole column from Sheet B to be referenced onto Sheet A. I thought I could reference the first cell from Sheet B onto Sheet A and then drag that reference to the rest of the cells in the column. I attached pictures to show what I would like to accomplish. The only solution I have found so far is to reference one cell at a time.
If you doing a sequential set of cells and only get their values, I would suggest cell linking instead of a formula. It is a simple process to select a range, copy the data, and the paste-special for links to the data.
https://help.smartsheet.com/articles/861579-cell-linking
Thank you! This was very helpful!
Looking to calculate the % of empty cells in a sheet for all rows that have data, with the intention of excluding any rows beyond my last row. I'd like to use this to motivate relevant stakeholders to completely populate the columns. Thank you.
So here what I'm trying, I have multiple solution and status for all. Trying to get the total net worth value of order based on solution + individual status. Let's say I want to capture the total revenue for Centralised Inventory with all different status as below: I tried with Sumifs but it's not calculating all values.…
I have an Action Log and in the log we have a column that identifies the different projects our team leads. There is also a Workstream column, which identifies what workstream is responsible for getting the answer. There can be more than one answer, so we have a dropdown and if multiple workstreams are responsible for the…
