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

Samuel Fortin

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

{{Chargé de projet}}

{{Adresse email chargé de projet}}

{{No de téléphone chargé de projet}}

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

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

or

[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.