How to copy a row with formulas to another sheet

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.

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