I'm trying to randomly assign one of four Group IDs (AlphaGroup, BetaGroup, GammaGroup, DeltaGroup) to all existing/new records in my database whether they're imported in bulk or added manually. I've been using this formula—however since some of my records will be imported in bulk, their created time remains the same and gives them all the same Group ID). I also have First Name, Last Name, Email, and other fields that could potentially be useful here. Any idea how to address this? Thanks!
IF( SECOND( CREATED_TIME() ) < 15, "AlphaGroup", IF( SECOND( CREATED_TIME() ) < 30, "BetaGroup", IF( SECOND( CREATED_TIME() ) < 45, "GammaGroup", "DeltaGroup" )))
Solved! Go to Solution.