Formula Autofill Fails with Sheet Summary References

Welcome to the New Smartsheet Online Community


You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.

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

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    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! 

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • 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

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    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!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

Sign In or Register to comment.