How to reference Sheet Summary cell in the text of an automation?

I've been usign columns references in the text of my automations messages a while now. It looks like that. The text is in french but you can see the symbols used.

Bonjour {{Fournisseur}}

Voici la confirmation de commande pour le projet {{Projet}}.

La date de début est le {{Date de début}}

La date de fin est le {{Date de fin}} inclusivement

I wonder if it's possible to do the same thing with sheet summary cells. I've tried {{#cell}} but it doesn't work.

Find more posts tagged with

Automations

Sheet Summary

References

Accepted answers

All comments

Jason Tarpinian

Yup, you can! The # just goes on the outside, and you use square brackets, so it would look like:

=[Sheet Summary Field]#

Samuel Fortin

Thank you Jason,

I've tried just like you said, with the "=" or not, with "{{}}'' sign or not but I always get only the text i've written in the email or the message that my reference does not exist on the page.

What I receive:

=[Chargé de projet]#

Samuel Fortin <samuel@brulottepoitras.com>

418-998-8004

[Chargé de projet]#

Samuel Fortin <samuel@brulottepoitras.com>

418-998-8004

Jason Tarpinian

My apologies, I see what you're trying to do now. So you can't go DIRECTLY from Sheet Summary to the automation, since it is based on row specific data. So you'll have to use the =[Sheet Summary Field]# to populate a cell (you can make it a column formula then, so that it'd be available to all rows), THEN you can reference that field in the automation.

Samuel Fortin

I understand, do you how I can propose that as a new feature from this post

Jason Tarpinian

You can use the Product Feedback Form here for new ideas.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.