Exclude Rows when Sending Alert

PharaK SupportServiceManager

Hello,

I'm deep into automation and I want to say it's a brilliant technology. I'm not writing emails anymore to clients who submit forms to confirm their registration or further instructions. All this is done in Automation.

All I want to know is if there is a way to send the alert (email) without displaying all the rows?

Thank you. 😎

Andrée Starå

Hi,

If you go into the Advanced Options and check the box as the screenshots below,

and no columns are selected. It should work.

Would that work?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi,

If you go into the Advanced Options and check the box as the screenshots below,

and no columns are selected. It should work.

Would that work?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. It will make it easier for others to find a solution or help to answer!

Unknown

This content has been removed.

Unknown

This content has been removed.

Andrée Starå

Unfortunately, it's not possible at the moment, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment to have your vote added

The third-party service, Zapier, is an excellent option for this scenario. Is that an option for you?

Unknown

This content has been removed.

Andrée Starå

Happy to help!

What happened?

Have a look and see if you can patch things up! 😂 

A lot has happened with Zapier during two years.

Unknown

This content has been removed.

Andrée Starå

Ok. That's understandable!

And, thanks for the kind words!

There are other third-party options if you need/want to explore those.

Let me know!

Unknown

This content has been removed.

Andrew Stewart

Hi Director62476,

If you use Office 365, I would highly recommend you try Power Automate (renamed from Microsoft Flow). There is a connector for Smartsheet, and it appears to me to work a bit better than the Zapier connector. I have tried a Zap to monitor for changes in a Smartsheet, and my Zap would be blocked because when a row is inserted, the rowid for every subsequent row changes, and so the Zap would fire a multitude of times 😯

Regards,

Andrew

Andrée Starå

@director62476 I agree with Andrew, Power Automate is another excellent option so test that one first and let me know if you need additional options.

@Andrew Stewart I don't know when you tested Zapier last, but it's now easy to structure it, so that doesn't happen.

Unknown

This content has been removed.

Andrée Starå

@director62476

Excellent!

I'm always happy to help!

Let us know how it goes!

Unknown

This content has been removed.

Andrée Starå

@director62476 Have a look here!

https://flow.microsoft.com/en-us/connectors/shared_smartsheet/smartsheet/

https://docs.microsoft.com/sv-se/connectors/smartsheet/

Did that help?