Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Auto Assign Tasks

edited 12/09/19 in Archived 2017 Posts

I am trying to create a workflow that will change an "assigned to" cell dependent on a number of cell that will be checked, for example:


If the product needs to be delivered to the customer then the "product sent" checkbox is blank triggering a " Assigned to Sales Person" if the checkbox is checked then the "assigned to" cell moves to "Project Manager". 


I can use a formula to complete this with a single task but not with multiple. 

=IF([Sample Request Submitted]1 = 0, "Sales Person", "Creative Services")


IF([Samples Delivered to Sales/PM]1 = 0, "Creative Services", "Sales Person")

But I can't seem to combine them. Thanks. 

=IF([Sample Request Submitted]1 = 0, "Sales Person", "Creative Services"), IF([Samples Delivered to Sales/PM]1 = 0, "Creative Services", "Sales Person")

 - Eric




This discussion has been closed.