sheet summary- how to get EXISTING fields
Sheet summary explains how to ADD new fields to summary but no apparent way to add existing field from the sheets???
Answers
-
Hi Tanya,
Not sure I follow? Do you want to add Sheet Summary Fields from another sheet?
Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
I hope that helps!
Have a fantastic weekend & Happy New Year!
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.
-
There are no existing fields until they have been created. You would need to create whatever fields you need.
-
Thanks Paul.
So if I want the sheet summary to include fields from the sheet I am summarizing I have to recreate them, making sure to get spelling and type and all to match exactly?
I think I am not comprehending the purpose of sheet summary, because this seems very labor intensive.
-
You can label Sheet Summary fields however you want. You do not need to "fit" them into anything other than what works best for you.
If you prefer "Start Date" instead of "Start", then you can use "Start Date". The only thing you will need to remember if you are following step-by-step instructions is that field names referenced by formulas will need to be the field names you are actually using.
-
I'd recommend either creating a template with the Summary Fields you need and then use that sheet template for new sheets, and that would include the Summary Fields. Or if you already have a few sheets with the same or similar structure, you can add the Summary Fields to one and then copy the Sheet Summary Field structure to the other sheets.
Make sense? Would that work/help?
More info:
✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. It will make it easier for others to find a solution or help to answer!
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.
-
I know this is a fairly old thread and hopefully Tanya has figured out the answer. I think the answer is to simply add a formula to the newly created sheet summary field (named whatever you wish) =[Column Name]x - where x is the row number for the cell you are referencing. At least that's how I'm reading the question.
-
What is the syntax if you want x to be static. Now when a new row is added, the sheet summary field changes to x+1?
-
@QYou What exactly do you mean?
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 463 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives