Use Summary Field as dynamic field in message

Aloha!

I have a workflow that needs to report on summary field totals that I want to be able to trigger an alert notification message for ...

Mahalo!

Sign in to vote!

Find more posts tagged with

Idea Submitted

Comments

Andrée Starå

Hi @Char T

I hope you're well and safe!

Here's a possible workaround or workarounds

Add a so-called helper column that references the Sheet Summary Field and convert it to a column formula so it's included on all rows.

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

Char T

Mahalo! That worked as far as being able to create a notification alert and use the column fields with the Message Only option, but now the challenge is that I only need that to appear for the 1st instance per day - i.e. I have staff submitting their orders for tomorrow and the helper columns are summarizing that, but when I create the workflow, how do I make it so that it will only generate one alert?

Quick Links

Trending ideas

Automatically Identify, Notify, and Archive Inactive Smartsheet Assets
Problem Smartsheet environments quickly become cluttered with inactive Sheets, Reports, and Dashboards that are no longer viewed or updated. This creates confusion for users and significant overhead for admins, especially in large or regulated environments. There is currently no native way to automatically identify, notify…
Auto-resizing of Calendar App
Having the ability to auto-resize the Calendar App view based on the widget size is needed. We have a "Due in 7 Days' calendar for our dashboards and would like it to be anchored at the top right. Unfortunately, as currently designed, the calendar takes up a significant amount of space and must be moved to the bottom.
Column Formula & Automation Gaps in Global Updates under Control Center
I am loving the capabilities in Global Updates under Control Center.However, there are some gaps I would really like addressed.Can we please create a Global Update option to do the following: Update a column formula not just a cell formula Update an automation Note: I know that I could create a new column and delete the…