Workflow incorporating "AND"
I have a smartsheet that consists of rows of information some 100 columns wide and am trying to set up a single workflow that says:
When you reach "this date"
Check these specific10 columns for each row and if any of them contain a number that is greater than 0 send an email to:
this person if column 1 is greater than 0,
AND
this person if column 2 is greater than 0,
AND
this person if column 3 is greater than 0
AND .......etc.
I'd appreciate any help, it seems as usual with new users, the swap from Excel to smartsheets is not proving as simple as I'd hoped?!!
Answers
-
I would suggest setting up separate automations for each column you want to evaluate since it looks like the recipients could vary depending on which column is triggering it.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Thanks Paul,
I suspect I may have to do exactly that.
Not the most elegant solution I have to say, as on the given date I may have workflow 1, 3, 4, 7, 8 and 9 out of the 10 triggering an email be sent. Then a week later I'd need to run another 10 workflows to trigger emails from any of these 6 columns that still haven't reached 0 and so on for as many weeks as as it takes
Essentially I'm trying to check every week that the required data has been entered (answer to equations in "checkcolumns" is now 0) and send emails to those responsible for any that still aren't.
Excel?🙄 or do I just need to get my head around a different set of limitations in smartsheets a bit more - we shall see.
Thanks again
-
Depending on your exact needs, you could set up the automation to run on a weekly basis and then set your conditions.
Once you set up one, you can duplicate it and then only have to adjust the condition portion and the recipient portion.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives