Helper Columns & Sheet Summaries

Nina R

Hi,

Can you tell me how to link field from summary sheets into a cell on a different sheet in Smartsheet? I have seen other chats on using helper columns, but nothing that provides guidance on the proper formula to use to pull that information. Is there a way to do this?

Monique_Odom_Comcast

Hello @Nina R,

Unfortunately Sheet Summary fields cannot be linked or used in cross-sheet functionality. Creating a helper column is the current recommendation for referencing this information on other sheets.

I would also recommend adding your support to this feedback discussion:

https://community.smartsheet.com/discussion/102376/reference-sheet-summary-data-from-another-sheet

SteyJ

https://community.smartsheet.com/discussion/118235/helper-columns-sheet-summaries

It's not possible to pull directly from the summary fields to another sheet. You can reference a sheet summary field in a cell on the sheet, and then cell link it to another sheet, or cross reference it with a lookup method like INDEX/MATCH

Nina R

thanks Monique. Do you know the appropriate formula to pull in the helper column for a sheet summary? I can't find anywhere that shows how to do that. The post you shared seems to point to frustration, but now how to do it.

Andrée Starå

Hi @Nina R

I hope you're well and safe!

Unfortunately, it's not possible now, but it's an excellent idea!

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

• A workaround would be to link the information to the sheet in helper columns or specific cells.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!