Placeholders in Automation Message not recognizing column name

reece.buckner

I am trying to create an automated update request with placeholders {{ }} to make the messages more useful as the sheet has many projects on it and the receiver would not immediately know what the message is referencing without the placeholder information.

Most of them work (Owner, Project Info) as you can see here:

{{Project Name}} is the one which will not work for me. It also does not work on other sheets I have tried this on.

As you can see, the column does in fact exist:

The values in the project name column are generated by

1. @row for the parent row
2. =parent() for the child rows

Can placeholders not be used on columns which are being populated by formulas?

Andrée Starå

Hi @reece.buckner

I hope you're well and safe!

It should work!

Double-check the column name so there's no space after or similar, and do the same with the placeholder.

Yes, it works with columns with formulas.

Did 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!

Andrée Starå

Hi @reece.buckner

I hope you're well and safe!

It should work!

Double-check the column name so there's no space after or similar, and do the same with the placeholder.

Yes, it works with columns with formulas.

Did 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!

reece.buckner

@Andrée Starå thank you! I had a space after the name in the column header. This was driving me a little crazy.

Andrée Starå

@reece.buckner

Excellent!

Happy to help!