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,
this person if column 2 is greater than 0,
this person if column 3 is greater than 0
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?!!