Hi Community! The new Randomitem function is just in time to help me, but I can’t quite get it to do what I need.
What I have a is hefty table where each row represents a school district’s application. Each row also includes a point of contact (POC). Many, but not all, applications will expire June 30 and they will need to be assigned a new POC. Since there are over 300 applications and we have a team of 5, I’m trying to find a way to assign the team equitably across the expired applications.
I cannot use a column formula because some applications will NOT expire until next year and those POCs need to remain in tact. I have already worked out a formula to correctly label those that have expired and a button to make the POC blank for any expired applications.
So, enter the new button with a filter to only affect rows where the POC is blank.
Right now, I have a small, separate table with the list of potential POCs - Application Reviewers.Reviewer - from which to pull the values. My button formula right now is simply RandomItem(Application reviewers.Reviewer).
The randomitem function is working, however, it picks one random item from the list and then assigns that selection to EVERY row. What I need it to do is a choose a NEW random item for each row. Can anyone help me out?