Placeholders in Automation Message not recognizing column name

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?

Best Answer

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Answer ✓

    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!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Answers