How to copy a row with formulas to another sheet

Kevin Broederlow

Hello all

How can I copy a row with drop downs and formulas to another sheet, when I copy these the formulas dont work, I have tried copying the row and selecting all cells but nothing works

 

Thank you in advance

J. Craig Williams

Kevin,

 

Try ONLY selecting the cells. Don't use any of the shortcuts.

Those don't bring over the formulas.

If you select the row by cell (instead of the whole row), they should come over fine.

 

Dropdown lists are a column feature, not a row or cell feature.

Craig

Kevin Broederlow

Hello Graig

 

Thank you for your reply

My formulas are not in one column or row, they are spread out and referencing to others depending on what the imput is, I can do the same copy and paste in excel and microsoft office project but not here

I dont mean to sound rude but can I assume that smartsheet does not have the same capibilities and is limited in this aspect?

I am new to smartsheets and it is a very powerfull software from what I have learned and if it can not do a copy and paste thats ok I can work around this

 

Thank you Graig

J. Craig Williams

Kevin.

 

I don't work for Smartsheet, you can be as rude as you feel you need to be. 

Probably even if I did.

 

I sympathize with your problem.

Smartsheet does support both absolute and relative cell referencing.

Both can be problematic when copying or moving a cell or group of cells between sheets. I would imagine one exists, but I have not found a definitive guide to this.

It has been a while since I searched for one.

 

This article

 

http://help.smartsheet.com/customer/en/portal/articles/518318-using-copy-paste

 

says this about formulas

 

To copy and paste formulas: Use the instructions above to copy cells and rows containing formulas within the same sheet. To copy a formula into a different sheet, double-click on the cell containing the formula to expose it. Highlight the formula with your mouse and press [Ctrl] + C to copy it. Open up the other sheet, single-click on a cell and press [Ctrl] + V to paste it in. You may need to modify the cell references to make them appropriate for this sheet

 

Bold-italics highlight is mine.

That is a serious understatement.

 

Smartsheet is not always complete replacement for Excel, MS Project, or many other tools and programs. What is does best (in my opinion), is it allows some (I wouldn't even say most) of the features (but perhaps most of the key ones) of those programs where it comes to collaboration. The important thing (again, my opinion) is to figure out how it fits into your workflow and how it connects to the other pieces, like Excel.

Perhaps you don't need to copy/paste, perhaps what you need is cell linking.

It really depends. For one of my latest problems, I really need copy/paste, though.  

 

Craig

 

 

 

Kevin Broederlow

Graig

 

Thank you so much for your advice and opinion,  I really do appriciate it and I think you are right,  I am still working on my work flow and may need to revise how this is set up for me

 

Kevin