Sheet Summary
Hi,
When copying a sheet summary to other sheets within the same workspace, it carries the field names but not always the information within the field. For example, after having copied the sheet Summary, the "Completion %" shows =[% Complete]30 + " %" or #UNPARSEABLE, instead of an actual number, ie. 50 %. There's no option to link the field to the actual information from another sheet, is it?
Thanks
Answers
-
Hi Mozetto,
The sheet you're copying the Sheet Summary to has to have the same column, column types, and names as the original for it to work.
Did both sheets have the same columns?
I hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi Andree,
Thank you for your explanation, it makes sense. In our case each sheet has different information on the same project.
Take care
-
Happy to help!
We could probably make it work with a couple of helper columns on the sheets where the columns don't match up.
Would that work?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi Andree,
It is a good alternative. I was hoping to take advantage of the information gathered within the Sheet Summary fields instead of what's within the sheet itself.
I appreciate the feedback!
-
Can you explain in more detail how you would like to use it? There might be a solution/workaround.
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives