Email Notification - Limits to Columns in Message?

Courtney Collier

Our clinic managers perform a monthly Joint Commission readiness walk-through for each clinic (approx 125). I have built a form for them to document their results for each question - Compliant vs. Non-Compliant. When setting up a email notification to send the results to the regional directors, there seems to be a limitation to the # of columns to include in the notification. I still have 39 more columns to include. There are roughly 140 columns I need to include. I have been unable to find a work around. Reaching out to confirm that there are limitations and to get some advice on workarounds. The goal is for the regional directors to receive the results of the walk-throughs for each of their clinics when a walk-through is documented using the form. Thanks for reviewing.

Andrée Starå

Hi @Courtney Collier

I hope you're well and safe!

You could use the Placeholder feature.

More info: 

https://help.smartsheet.com/articles/2477796-dynamically-add-cell-data-in-the-subject-and-body-of-request-messages

Would that work/help?

I hope that helps!

Have a fantastic weekend & Happy New Year!

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!

Courtney Collier

@Andrée Starå Thanks for replying. Yes, that is the approach I attempted. See the screenshot at the bottom - 39 more columns. They are not showing to select to include in the message. I am able to send the row, manually, from the sheet, but that is not scalable in this situation. I need a way to send the message, with all columns, to show the RD's where there are deficiencies in their clinics.

Andrée Starå

@Courtney Collier

Happy to help!

It doesn't seem that you're using the Placeholder feature but instead selecting the columns you want to be included.

The placeholder is added to the message {{Placeholder Column Name}}

Have you tried that?

✅Remember! 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!

Courtney Collier

@Andrée Starå Thanks for the response. I was able to add the additional 39 column by starting to type the name and selecting. It was not intuitive at first. Thankfully that worked without having to type out 120+ column names in brackets. Now if Smartsheet would allow conditional formatting to work in the messaging, I would be set :) Thanks again!

Andrée Starå

@Courtney Collier

Excellent!

Happy to help!

✅Remember! 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!