I'm using a custom auto-number field in combination with a Date and a Time fields to create a sort of priority list with which requests are processed. I'm facing a problem with requests that are already in the queue and users go in and and change the Date or Time (this is a valid action) but since the auto-number doesn't change those changed requests are processed using the same order they came in. I need these changed requests to get a new auto-number and go to the bottom of the list for processing. One caveat is that the auto-number is assigned in my intake sheet and requests are moved automatically to various other sheets depending on the date. I created a workflow to move changed requests back to the intake sheet and tried the Clear Field action before the move but, it doesn't allow my to clear an auto-number field. Any workaround? Any help would be greatly appreciated. Thank you.
Help Article Resources
Check out the Formula Handbook template!