Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

How to copy a row with formulas to another sheet


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
    J. Craig Williams ✭✭✭✭✭✭



    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.


  • 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
    J. Craig Williams ✭✭✭✭✭✭



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

    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




    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. Laughing 






  • 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



This discussion has been closed.