Assign to Account Manager when status changes
![alys](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
I am trying to create a workflow so that when a Status changes to 'Available in Partner Album,' the person listed in the 'Account Manager' field is automatically assigned to the task in the 'Assigned To' column. When I create the workflow, it asks me to select a specific person, but I want it to pull whoever is listed in the Account Manager field for that task. Is this possible?
Best Answer
-
It would be a nested IF statement.
=IF(Status@row = "1st Status", [First Assignment]@row, IF(Status@row = "2nd Status", [Second Assignment]@row, [Third Assignment]@row))
Answers
-
You would have to use a formula for this. Do you have the rest of the people that would be assigned listed out in other columns?
Otherwise, this is not possible in the core product. You would need to leverage a third party app, the API, or the premium add-on Bridge.
-
@Paul Newcome I don't have the others listed out in columns, but I could do that. Would the formula be if the status is 'status 1' assign to the person listed in column 1?
-
It would be a nested IF statement.
=IF(Status@row = "1st Status", [First Assignment]@row, IF(Status@row = "2nd Status", [Second Assignment]@row, [Third Assignment]@row))
-
@Paul Newcome Thank you!
-
Happy to help. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 351 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 36 Webinars
- 7.3K Forum Archives