Auto Assign Contact based on number of Open Tasks
Any help would be great. I have a form that dumps information into my sheet and would like to auto assign the task to a person/contact when it comes in.
The Assignment is on a rolling basis. For example I have 4 people and as the work comes in it gets assigned to each one then starts again at the top of the list.
Has anyone done this?
Thanks!
Answers

Hi Christina,
There isn't a specific function that would automatically fill this information in on a rolling basis, but we may be able to create something similar with helper columns.
You could first create a new text/number column that will be your numbering system (I called mine "Row Number"). In this column, enter "1" into the first cell. Then put this formula into the second cell:
=IF([Row Number]1 = 1, 2, IF([Row Number]1 = 2, 3, IF([Row Number]1 = 3, 4, IF([Row Number]1 = 4, 1))))
Dragfill this formula down your column for all your current rows. You will now have an autonumbering column that will repeat back to 1 after reaching 4. I would suggest hiding this column so no one adjusts the formula.
Then in your contact column, you will need to assign each one of your 4 users to a number, like so:
=IF([Row Number]@row = 1, "userone@email.com", IF([Row Number]@row = 2, "usertwo@email.com".... etc
Formulas will autofill when new rows are created, as long as they are present in two rows above the new one, so these will autopopulate when a form is submitted. (See here)
Another alternative would be to use a COUNTIF formula to count each person's total rows, and manually assign the task to the person with the lowest number.
If you're having trouble with either of the formulas, please provide a screen capture and I'm happy to help!
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8  10, Seattle, WA  Register now
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.4K Get Help
 364 Global Discussions
 200 Industry Talk
 429 Announcements
 4.4K Ideas & Feature Requests
 137 Brandfolder
 129 Just for fun
 128 Community Job Board
 446 Show & Tell
 28 Member Spotlight
 1 SmartStories
 284 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!