How to send an automation to multiple contacts in another sheet?

SPBops · 2023-07-17 19:55:57

Sheet A has a column of email addresses, the quantity of which is always unknown (could be 5 rows today, 10 rows tomorrow) and the content is not always static as people change roles (email x may be changed to email y tomorrow). Sheet B has an automation to request an update when a row is updated. How does Sheet B sent the…

Options

Answers

AMCGil ✭✭✭

04/23/24
Options
@Paul Newcome, any word on if this Product Idea has been/ will be implemented? The join collect function has worked wonderfully to pull in multiple emails, but as described above, will not work with automation.
Thanks!

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Trending in Formulas and Functions

How do I pull in a value using 2 criteria?
I want to use Project Name and Resource name as a criteria to pull hours worked into a different sheet. Please help.
VLOOKUP and COUNTIFS
Hi all, Hoping to get some help with a LOOKUP/COUNTIF formula. I'm trying to create a grid that counts issue location by month. I've created this column in the source sheet which is the range for the VLOOKUP. The sheet that this information needs to be pulled to: I'm struggling to create a formula that will count each…
Whats the formula to find todays date between a range of dates to provide a value?
i need a formula to find todays date between the start date and end date, then provide the current sprint

How to send an automation to multiple contacts in another sheet?

Answers

Help Article Resources

Categories