Formula Autofill Fails with Sheet Summary References
I have information from my project information sheet (Project ID, Project Manager, Project Name...) linked into the sheet summary of my schedule, risk, issue, and other project management sheets. I then link this information into the sheet via the formula =[Sheet Summary Field Name]#. Otherwise associating a particular risk, issue, or other item to its project at the portfolio level would not be possible with row reports.
When I add a row to the bottom of the sheet, the formulas autofill just fine. When I add a row via a form, the formulas do not autofill. Formulas that reference the sheet (=[Sheet Column Name]$1) will autofill when a row is added in the sheet or the form.
What are your thoughts on addressing this issue? I can link the data into the sheet and then reference the sheet on the sheet summary. I felt it was more efficient to link it into the sheet once. By placing it in the sheet summary, the link to the other sheet is unlikely to be deleted by the project managers. If I place it in the sheet and the row with the cell linking is deleted, the data is gone from the entire sheet.
Answers
-
Hi Pamela,
I read that there is an issue currently with the formula autofill, Sheet Summary, and forms.
I’ll get back to the post if I find the original post.
I hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. 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.
-
Hi Andrée,
Thanks! If it is considered an issue, then hopefully it will be fixed soon.
May you have a fantastic week also! Mine will be better when this is resolved. :)
Warm regards,
Pamela
-
Happy to help!
✅Remember! Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. 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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!