Trouble copying formulas into new sheet

Options

Hello All!

I am having difficulty copying formulas from one sheet to the next- I keep getting "UNPARSEABLE". I have tried copying/pasting in multiple ways, no luck.

Details: Formulas look like =COUNTIFS(Type:Type, "GC", Team:Team, "TM") , "Type" and "Team" being columns in each separate monthly sheet. If the columns are named the same, shouldn't pasting the formulas into the new sheet load the data from that sheet?

Thank you in advance for any advice!

Tags:

Answers

  • Brian_Richardson
    Brian_Richardson Overachievers
    Options

    Yes copying should work fine. There's probably a subtle difference in the column names, an extra space or something. When you paste the formula you should see the column names turn color…if they are still black then that means it's not finding those columns on the sheet that you're posting to.

    Another problem may be that your paste is not including the trailing ) which will also result in UNPARSEABLE

    BRIAN RICHARDSON | PMO TOOLS AND RESOURCES | HE|HIM

    SEATTLE WA, USA

    IRON MOUNTAIN

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!