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!
How do I see who submitted a form for a specific sheet?
Hi, I have a Gantt covering 500+ rows of events past and planned. I use it to predict and track values around these events. Using helper columns to identify the current week, I get an email report on a Monday that tells me the upcoming events in the current week (7 days) and their values. Currently if an event spans…
Hi Smartsheet Community, I'm working on an action management system where users create sub-actions through a Smartsheet Form. The requirement is simple: a sub-action's due date must be earlier than or equal to its parent action's due date. For example, if the parent action is due on June 30, 2027, users should not be able…
