Dynamic Fields Issue - Subject Line Issue

06/10/21
Answered - Pending Review

So... intermediate knowledge of Smartsheet.

Weird issue. I've tried messing with the syntax and arrangement...


Subject 1: "{{MeetingID}} - Notes"

Automation Email Subject 1: "Changes to Meeting Log - Project: Project Meeting Minutes"

Subject 2: "{{MeetingID}} - Action Assigned"

Automation Email Subject 2: "Team Huddle - Enterprise Apps - 06/10/21 - 09:30 AM - 10:00 AM - Action Assigned"

I'm confused.

Popular Tags:

Answers

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi @C. Colin Schultheis

    I hope you're well and safe!

    Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

    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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Here is the side by side of the two. The "action assigned" subject is fine. the Meeting notes is not.

    Could it be that I'm returning multiple rows? that doesn't make a lot of sense, but might explain it.

    Either way, I hate it.

  • Mike WildayMike Wilday ✭✭✭✭✭

    Can you provide a sample of the data you are pulling this from? It might help sculpt the solution. The headers and some sample info would be very helpful in deciphering what's going on.

  • @Mike Wilday if it helps, it is the same exact sheet.

    That's what is so confusing.

    The difference I see:

    1) Meeting notes-- sends several rows

    2) Action item -- sends a single row

    META-- Replace MS OneNote, run all meetings from Smartsheet and have the data filed/organized and reportable in a meaningful fashion. That requires a certain aesthetic. Right now, the FUNCTION works well, but the subject is not ideal or customized in #1. #2 is perfect.

    If you still need details, I can send them. I've been doing database builds for about 25 years or so and it's taking me a moment to figure out the workarounds to the shortcomings of Smartsheet

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    @C. Colin Schultheis

    This is probaly why.

    Placeholders will generate separate notifications when using placeholders with Alert or Update Request actions in change-based workflows if six or fewer rows are triggered simultaneously. If seven or more rows are triggered at once, the custom subject and body will be removed.

    Make sense?

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Sign In or Register to comment.