Excel Power Automation - Sending Emails to Users Based on Sheet Criteria

Our take

Hello everyone! I'm exploring the transition from Smartsheets to native Excel for task management, particularly using Power Automation to send emails to users based on specific criteria in our task list. While my current automations effectively notify users of overdue tasks, I often encounter new issues each month. Unfortunately, I've hit a roadblock with Power Automation, as it seems to send emails to only one designated person instead of the relevant task owner.

Hi All!

My organization currently uses a website called Smartsheets to create task lists. I've created automations that run each morning that send emails to users if a task becomes past due.

It fulfills the intended purpose; however, every single month there seems to be some new issue; therefore, I'd like to transfer over to using functionality in native Excel.

My research turned me on to Power Automation. I found the tools I needed until I hit a roadblock: P.A. does not look at the contact within the sheet and send a message to that person. It appears to just go to one designated individual.

Any thoughts, recommendations, or solutions? I am almost at the end of my rope and ready to just deal with Smartsheets.

A screenshot of our task list can be found in the comments. Maybe it provides some reference that I missed.

Thanks!

submitted by /u/bltsmith
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article →

Tagged with

#Excel compatibility#Excel alternatives for data analysis#Excel alternatives#rows.com#automation in spreadsheet workflows#generative AI automation#workflow automation#cognitive automation#self-service analytics tools#enterprise-level spreadsheet solutions#AI-native spreadsheets#business intelligence tools#collaborative spreadsheet tools#AI-driven spreadsheet solutions#financial modeling with spreadsheets#no-code spreadsheet solutions#cloud-native spreadsheets#data visualization tools#data analysis tools#data cleaning solutions