Trouble copying formulas into new sheet
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!
Answers
-
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
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 352 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 135 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!